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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-24 : 07:42:28
|
| Anand writes "Hi, I am facing a problem here in SQL Server related to the fixed server roles.We have a command “Set Identity_Insert ON” that requires a db_owner permission. We need to check how many other commands exists of the similar type that requires the fixed server role permissions. Could anyone let me know how to trace the commands that require the privileges of a fixed server role (Ex: db_owner , sysadmin ….)Any help is appreciatedThanks,Anand." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-24 : 13:37:07
|
| You are going to need to do a lot of reading in SQL Server Books Online to figure this out as there is no command to get this information. And you should not be granting all of these permissions to your users. You should know what your application requires and provide only those permissions and nothing else.Tara |
 |
|
|
|
|
|
How do we retrieve privileges of a fixed server role