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 |
|
Christech82
Starting Member
20 Posts |
 Posted - 2013-05-05 : 16:32:41
|
| Hi I had been asked to create roles for the manager of the company as I know the manager is dealing with the staff details and also manages many other function in the site. I would like to know in description what and what kind of roles that I can grant the manager?! Is it gonna be on specific tables and columns OR all tables ?? Thank you. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-05 : 20:51:44
|
quote:
Originally posted by Christech82
Hi I had been asked to create roles for the manager of the company as I know the manager is dealing with the staff details and also manages many other function in the site. I would like to know in description what and what kind of roles that I can grant the manager?! Is it gonna be on specific tables and columns OR all tables ?? Thank you.
It really depends on what you want the people who are managers should be allowed access to. For example, if they should be allowed to view the data in certain tables, but not modify that data or view data in other tables, you would create the role and grant select permissions to only those tables.So the first thing to find out is: what should and should not the managers be allowed to do. Just because they are managers, don't make the assumption that they should be allowed to do anything and everything to the database. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-06 : 01:42:36
|
| see this to get an understanding on how to add custom roleshttp://msdn.microsoft.com/en-us/library/aa905188(v=sql.80).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Role 2