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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-06-25 : 16:26:54
|
| Can anyone tell me the consequences of 'dbo' user not being associated with 'sa' login?Does that mean you cannot perform certain database related tasks which only sysadmins (like sa) can perform?DB maintenance backup plans work fine.Thanks,Sarat |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-06-25 : 20:57:50
|
| sa gets permissions as part of the sysadmin group and can do anything on the server.Your dbo user will be able to do anything to that database but may have problems outside it depending on which groups it is in.e.g. may not be able to create new databases or perform security functions.Look at the fixed server and database roles.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
dbo user with sa login