February 13, 2002 at 12:41 pm
Does anyone know why I am unable to issue a ALTER DATABASE command as a db_owner in SQL Server 7.0? I did the same command in 2000 and was successful. When I try this in 7.0, I get an error message saying that I need to either be in the sysadmin role or be the database owner. Any ideas?
February 13, 2002 at 12:55 pm
You sure that the login you're using is in the dbowner role?
Andy
February 13, 2002 at 1:02 pm
Absolutly positive. Like I said before I am using the same permissions on both 7.0 an 2000.
February 13, 2002 at 2:07 pm
Could you post the alter? Maybe a difference in the compatibility mode?
Andy
February 13, 2002 at 2:17 pm
ALTER DATABASE
ADD FILENAME <filename>
February 13, 2002 at 2:18 pm
I am sorry, the ALTER is:
ALTER DATABASE XSQLDB
ADD FILEGROUP Test1FG1
February 13, 2002 at 2:33 pm
No ideas so far. This from BOL:
SQL2K:
ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These permissions are not transferable.
SQL7:
ALTER DATABASE permissions default to members of the db_owner and db_ddladmin fixed database roles, and to members of the sysadmin and dbcreator fixed server roles. These permissions are not transferable.
Andy
February 13, 2002 at 2:55 pm
I just gave myself the db_owner and db_ddladmin permissions and I am still receiving the same error. Thank you for the assistance though, I appreciate it.
February 13, 2002 at 2:59 pm
There's this, but it's through EM:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246588
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 13, 2002 at 3:07 pm
I also saw this, but I am not using EM. I am trying this in Query Analyzer and also a Debugger.
February 13, 2002 at 6:12 pm
Is it possible that the login is misaligned? Have you run sp_change_users_login to see if there are orphaned SQL logins? Or are you using NT login? Have you run sp_changedbowner to see what happens?
Andy
February 14, 2002 at 10:33 am
February 14, 2002 at 10:36 am
I am assuming that I have the correct permissions because I can do it in 2000, but not 7.0. Is it possible to find out somewhere if this is a 7.0 bug?
February 14, 2002 at 12:37 pm
You've looked in the Knowledge Base and I did a search there, too, and the only thing that came up was for Enterprise Manager, which doesn't describe the issue. Is it just your account? Can another account (say the sa account) accomplish this?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 14, 2002 at 12:38 pm
Yes, sa is the only account that can accomplish this.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply