September 7, 2006 at 7:40 am
Hello,
Win2003\MSSQL2005
How do i see the object level permissions associted with a database role using MSSQL Management Studio?
ie: selecting "database" > security > roles > database roles > "rolename" ... selecting this gives me the properties ie: members of this role/owned schemas ... how do i see the associated permissions ie: DML?
Many thanks. Jeff
September 7, 2006 at 7:47 am
Go to the object in EM and right click on it and see properties and then permissions - you should be able to view it there
September 7, 2006 at 7:58 am
thanks ... but is there a way to see all the objects at once? In MSSQL2000, using Enterprise Manager, there was a "Permissions" button when the db role's properties box was selected ...
Many thanks. Jeff
September 7, 2006 at 8:41 am
In QA - for the current DB execute:
sp_helprolemember
it will give you information for all members and their roles in the current DB
September 8, 2006 at 7:55 am
In SQL management studio,
Right click on the role you want to check the permissions for and select properties.
On the properties control, select the 'securables' page. The top window for 'securables' will be blank. The button is called 'Add'. It is not that intuitive but apparently 'add' means add an object to the securables window, in order to view its permissions in the bottom (permissions) window.
When you click 'Add' you will see the 'Add objects' dialog allowing you to choose the types of objects you want to populate the securables window.
After the list of securables is populated, you can highlight one of them to view (change) the permissions of the role for the selected object.
September 20, 2006 at 6:57 am
use the following:
EXEC sp_helprotect NULL, 'rolename'
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply