List all permission in all databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Alejandro Pelc » List all permission in all databases

12 posts, Page 2 of 2

««1 2

List all permission in all databases

Rate Topic

Display Mode

Topic Options

Author

Message

chumphrey 12211

Posted Wednesday, May 18, 2011 9:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:10 PM
Points: 28, Visits: 335

Also must be SP2 or higher. That is when OBJECT_SCHEMA_NAME was introduced.

Post #1111099

Preet_S

Posted Thursday, September 22, 2011 8:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:15 AM
Points: 236, Visits: 235

Hi Alejandro

What is the purpose of

select id, xtype from master.sys.sysobjects

is sys.objects not sufficient ?

Also would it better to change the join order i.e. if we are after permissions should we be using database_permissions as the base table.This will prevent nulls being returned where database roles have no explicitly defined permissions ?
We could just use where Permission is not null I guess.

Lastly how can we get schema names to appear under the object name column ? I am seeing the following permissions ;
ALTER
CONTROL
DELETE
EXECUTE
INSERT
REFERENCES
SELECT
TAKE OWNERSHIP
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION

with no object name. Clearly it applies to a schema but it would be useful to get the schema name.

Cheers
Preet

Post #1179439

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions