April 17, 2003 at 1:09 am
Hi,
I want to assign the user DB_ower database role. But this user should not add anothere user in his database. How can i achive this.
(Basically i need user should create the objects with owner dbo but they are not allowed to add another user in there database)
waiting for urgent reply
Prakash
April 17, 2003 at 1:56 am
SQL2000 ? Make the user DDL-admin in stead of DB_owner. Look at BOL.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 17, 2003 at 6:50 am
Keep in mind that if you give the user db_ddladmin and the user creates the object belonging to dbo, the user won't be able to assign permissions (you didn't say this was necessary but just in case it is). This requires db_securityadmin. Of course, with db_securityadmin, the user can add others to the database. So basically you (or another DBA) will need to manage permissions on the objects this user creates.
BTW, when you change ownership of an object (say from MyUser to dbo), the permissions reset; you'd still have to come back behind and set up permissions correctly.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 17, 2003 at 12:44 pm
you can assign DDL admin is sql 7.o as well. Thats good practice to avoid future problems.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply