DB owner cannot manage permissions using Enterpris

Question

DB owner cannot manage permissions using Enterpris

Frank Rosser

SSC Eights!

Points: 970
More actions
December 10, 2003 at 10:02 pm

#160471

Database Owner cannot manage permissions using Enterprise Manager.
I have created a database and granted the db_owner role to a user. But the user cannot manage permissions in the database using Enterprise Manager as the 'Manage Permissions' menu option is greyed out.
Doing the same thing using Transact-SQL works fine, so it does not appear to be a permissions problem.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

The user has registered the SQL Server with the proper credentials? This seems like a no-brainer, but it's always the first thing I check, having been burned before.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

Frank Rosser SSC Eights! Points: 970 More actions · Answer 2

Thanks for your reply.

The user has registered SQL Server with the correct credentials.

I check their connection by viewing 'process info'. I also replicated the problem by setting up a test user with the same privileges.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

What version and service pack of SQL Server? Does this happen on other databases?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

Frank Rosser SSC Eights! Points: 970 More actions · Answer 4

Windows NT - 5.0 (2195)

SQL Server 8.00.760 (SP3)

Enterprise Manager 8.00.194

I tried it on another instance on a different Windows server, and it works fine! The second instance is the same version.

As another test, I added the same user to another database on the same instance (where I am having the problem) - and it all works fine.

Appears to be an intermittent problem of some sort. I now suspect there is something wrong with the database.

e_h2324 SSC Enthusiast Points: 178 More actions · Answer 5

Off hand thought, try aliasing the user as 'dbo' and see if this makes a difference... shouldn't but worth a shot.

Frank Rosser SSC Eights! Points: 970 More actions · Answer 6

Problem fixed. There was something wrong with the one of the databases in the instance.

It looks like someone in the past removed the 'guest' user incorrectly. I applied the recommended fix from Microsoft Knowledge Base 315523 to correct the problem.

Interestingly there was other manifestations of the problem - 'no items' displayed when databases are listed in Enterprise Manager, and a very slow refresh. I traced this back to stored procedure sp_msdbuseraccess 'db', '%' throwing Access Violation exceptions.