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

Extract User-Role Mapping Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 8:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:11 AM
Points: 1,569, Visits: 56
Comments posted to this topic are about the item Extract User-Role Mapping
Post #601436
Posted Wednesday, December 24, 2008 9:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 20, 2013 12:45 PM
Points: 262, Visits: 94
Versioning is too specific. You'll have to update this code everytime you apply a CU or SP. Why not just look at the first character? Show us how without the cursor, there must be a set-wise way to do this.
Post #625451
Posted Wednesday, July 08, 2009 8:31 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810
I receive this error:
Msg 213, Level 16, State 7, Line 2
Insert Error: Column name or number of supplied values does not match table definition.

This does not look well...



Greetz,
Hans Brouwer
Post #749300
Posted Thursday, July 09, 2009 6:58 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:11 AM
Points: 1,569, Visits: 56
Hi Hans,

I am not getting any error, I have executed it & there is no
Post #750790
Posted Thursday, July 09, 2009 6:59 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:11 AM
Points: 1,569, Visits: 56
Hi Hans,

I am not getting "Insert Error: Column name or number of supplied values does not match table definition." Its working fine.

Please try again & let me know if there it still give problem.

Thanks

Sudhir
Post #750791
Posted Thursday, July 09, 2009 7:27 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:11 AM
Points: 1,569, Visits: 56
Hi Sigal,

Actually the only purpose to use cursor is to avoid DBO, SYS, INFORMATION_SCHEMA and Guest users, else we can directly execute sp_helpuser and it will return all user's role data.

To avoid cursor, while creating #tmpuser table, we can add another field with identity column and then run a while loop.

We have to run a loop to get roles of each user excluding system users.

your comments are appreciated.

Thanks

Sudhir
Post #750796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse