Extract User-Role Mapping

Question

Extract User-Role Mapping

Sudhirc

SSCommitted

Points: 1921
More actions
November 12, 2008 at 8:24 am

#195780

Comments posted to this topic are about the item Extract User-Role Mapping

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Myles Sigal Mr or Mrs. 500 Points: 579 More actions · Answer 1

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.

FreeHansje SSChampion Points: 11751 More actions · Answer 2

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

Sudhirc SSCommitted Points: 1921 More actions · Answer 3

Hi Hans,

I am not getting any error, I have executed it & there is no

Sudhirc SSCommitted Points: 1921 More actions · Answer 4

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

Sudhirc SSCommitted Points: 1921 More actions · Answer 5

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