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 - 2002-03-04 : 21:18:15
|
| velmu writes "I know that server role is for server level and database role is for database level. But I have a doubt. we have an user 'James' given sysadmin fixed server role. Can he do all the operationsin all databases or we need to grant fixed databaserole 'db_owner' for each database so that he canperform any operation in those databases.thanksvelmu" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 22:19:22
|
| sysadmin is the same as sa. They can do anything without explicit rights in the database.-Chad |
 |
|
|
|
|
|
fixed server role vs fixed database role