May 17, 2013 at 1:10 am
Hi !!!
I have a table like team list
TBL_Teamlist:
userid superid
101a AA1
102b AA1
201c AA2
Hear i need to asign to the perticular user is having a rights like 1.READ 2. write 3. read & write in front end application:
this is like providing a security
if anybody having the idea on this pls help me ie appriciated :-):
May 17, 2013 at 1:35 am
Hi Mahi, I'll not give you the exact solution, but here is the clue:
selectsu.uid, su.name, su1.uid, su1.name
fromsys.sysuserssu
inner join sys.sysmemberssm on su.uid = sm.memberuid
inner join sys.sysuserssu1 on sm.groupuid = su1.uid
This query provides you the userid's and their mappings.
Hope you'll be able to find your solution based on this query.
I will be looking out to see other solutions (interested). 🙂
May 17, 2013 at 9:33 am
Those are pretty old catalog tables now from SQL Server 2000. They've since been replaced by the likes of sys.database_principals and sys.database_role_members.
For more information, I'd suggest having a good read of the Books Online topics on security:-
http://msdn.microsoft.com/en-us/library/bb510589.aspx - links to topics
http://msdn.microsoft.com/en-us/library/bb283235.aspx - general overview
http://msdn.microsoft.com/en-us/library/ms178542.aspx - links to all the catalog views for security
Bear in mind that when querying the catalog views, many will only show you your own associated principals, system users and the fixed database/server roles unless you have the ALTER ANY USER permission, or permission on the user.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply