June 29, 2007 at 7:13 am
I've created a SQL user with a Server Role of dbcreator. The purpose is to allow users the right to create databases that will be deployed to clients purchasing our product. Some of our clients use SQL 2000, so the database that is created for them on our server needs to have the proper Compatibility Level. The problem is that the user creating the database cannot modify the the Compatibility Level.
At MSDN I saw that the dbo or a User with a Server Role of sysadmin can change the Compatibility Level. I don't want to give this user account sysadmin server role. When I look at the user's properties for the database they are the dbo.
Is this a problem in SQL? Any advice?
Thanks,
BigSam
June 29, 2007 at 9:27 am
Can your users create databases on sql server 2000 or sql server 2005 depending on what the clients have ?
June 29, 2007 at 9:31 am
s u right refer this link http://msdn2.microsoft.com/en-us/library/ms178653.aspx which says what privileges are required for using this proc.....but if u r able to create db with dbo then it shud work
[font="Verdana"]- Deepak[/font]
July 4, 2007 at 8:13 am
If the user is dbo in the database then he can change the compatability level for the database. He need not have sysadmin permissions to do that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply