March 23, 2009 at 11:31 am
I've got a strange problem with a database. We've set up a role that has complete admin authority on the box. This particular database will not allow me to right-click and select new index or delete.
Strangely enough, I can create the index manually, but I'd llike to see the wizard.
I belong to this role through network account in the domain. Per the IT people I have the same rights and they don't have an issue with this. So, i.e. it's only my problem. All attitudes aside, I looked at the role and verified the grants and actually went as far and granted that role every item there just to see what would happen. I'm not allowed to modify security roles on the box, so I can't say go create a new role and set it up.
Where do I start to look to resolve this? Any ideas would be appreciated. Thank you.
March 23, 2009 at 12:50 pm
Do you get an error when trying to get a listing? If so can you please paste that here?
What permissions does the security role have? Can it be they have deny on meta data access?
Try doing select * from sys.* tables to see if you can get to meta data for system using queries...
Do you have permission to run SQL Profiler? You can run that against SQL Server while you try to access objects using SSMS and see where the permission failure is coming in.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 23, 2009 at 9:14 pm
My issue was fixed by the information at this link:
http://www.writebetterbits.com/2008/09/debugging-sql-server-service-broker.html
Specifically, retaking ownership of the database back to the SA account.
Now who changed it, that's not a funny thing to think about. And when you
don't control the box...?
March 23, 2009 at 10:18 pm
heh orphan owner issue. I always set owner to SA for my databases :).
As for seeing who changed the owner *IF* you don't have lots of activity for DDL changes on server (production you shouldn't).
You can check the Default Trace log, it will have a "Audit Change Database Owner" event when the owner was changed. It logs when and who...
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply