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 |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2011-12-19 : 09:43:33
|
| I am having hard time to decide what level of permissions needs to be given..any help would be highly appreciated.There are 3 databases on the server and When a user creates a new database, then he should have complete access to the newly created database. I have given dbcreator in server roles but when ever the user creates a new database, he is able to create it but unable to access it. How can we give the required permissons in this scenario?? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-19 : 10:03:52
|
| Its not true.Any user who has created the database becomes the default owner of the database.PBUH |
 |
|
|
|
|
|
what level of permissions needs to be given