Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBUser Roles Script Expand / Collapse
Author
Message
Posted Thursday, December 1, 2011 1:09 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 5, 2014 9:54 PM
Points: 1,683, Visits: 451
Comments posted to this topic are about the item DBUser Roles Script


- Pradyothana


http://www.msqlserver.com
Post #1214941
Posted Tuesday, December 6, 2011 5:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 6, 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
Posted Wednesday, December 28, 2011 8:56 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:54 PM
Points: 326, Visits: 926
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
Posted Friday, December 30, 2011 4:34 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 6,178, Visits: 13,323
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"
Post #1228275
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse