Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mind_grapes
Yak Posting Veteran
71 Posts |
 Posted - 2009-06-15 : 06:34:42
|
| Hello all, INTRO:New to this world of Stored Procedures so will probably need a lot of help. I'm learning Stroed procedures daily, but have a project that is running in tandem with me learning of this new concept.BACKGROUND:the project is a new intranet, in which the structure was set up by my manager, however he is no longer here, and I have the task to keep it moving forward, and try my best to complete it. QUESTION:staff in the company need to have access to areas that relate to them and their department, and this has been set up with the aid of Stored Procedures. however I'm not entirely sure where they, or any additonal information (if any) needs to be / should be placed. Any help, or information would be great.Kind regardsmind_grapes |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-06-15 : 07:27:42
|
| I would personally of looked down the route of creating roles for each department, create views to show the data they need to be able to view, give the security rights to the view to the relevent related department role and then add users to the department role they are in |
 |
|
|
|
|
|
where to "exec" stored procedures?