April 9, 2008 at 8:08 am
Any way to drop a role from owning a schema? I am using the graphical Role screen and I can not uncheck the schema's that a role owns. This role is obesolete so I want to get rid of it.
I also can not see any graphical way to see what permissions a role has. I used the GRANT SELECT TO Reader to allow my Reader role have read-only access but I'm unsure how I can see if someone else granted DELETE to the reader as well - anyway to see this?
April 9, 2008 at 9:51 pm
To change the schema owner, execute the following query, making the appropriate substitution for **Schema Name** and **New Owner**:
ALTER AUTHORIZATION ON SCHEMA :: **Schema Name** TO **New Owner**
Once you've changed the owner, if the role owns no other schema, you should be able to drop it.
To see the permissions graphically, in SQL Server Management Studio, in the Object Explorer pane expand your database, expand the Tables folder, and right-click on the table and choose Properties from the pop-up menu. In the new dialog window, click on the Permissions page under Select a page. That will show explicit permissions against a particular table.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply