DBUser Roles Script

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 Pradyothana Shastry... » DBUser Roles Script

DBUser Roles Script

Rate Topic

Display Mode

Topic Options

Author

Message

Pradyothana Shastry

Posted Thursday, December 01, 2011 1:09 PM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,640, Visits: 423

Comments posted to this topic are about the item DBUser Roles Script

- Pradyothana

http://www.msqlserver.com

Post #1214941

Vu Do

Posted Tuesday, December 06, 2011 5:57 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 06, 2011 5:56 PM
Points: 4, Visits: 32

Hi Pradyothana, i don't see the DBUser Roles Script when click on this link. Can you post it again?

Post #1217502

pdanes

Posted Wednesday, December 28, 2011 8:56 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:36 AM
Points: 257, Visits: 690

Looks useful, but I get an error on the reporting database name. Is it because I am using Express version, or can I do something to make it work?

Post #1227409

Perry Whittle

Posted Friday, December 30, 2011 4:34 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 5,201, Visits: 11,153

avoid using the SYSUSERS table, sys.database_principals should be used instead. Incidentally, you make no provision for any certificates and their mapped users that may be in use

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1228275

« Prev Topic | Next Topic »

Permissions