SQL SERVER SCRIPT FOR LOGINS 1

[sendba]

Hai All
Does anyone know how to script all the logins along with the permissions ie whether he is have read , write privileges.

Help would be much appreciated

Regards
Sen

 

[Catadmin]

Senba,

What SQL Server version are you using? It makes a huge difference in the answer.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[sendba]

Hai CatAdmin

I am using SQL SERVER 2000 on ES 7000 Server.

Regards
Sen

 

[Catadmin]

Check out Flloyd's FAQ faq962-3374 for the link to Microsoft's KB article about porting over logins, etc.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[sendba]

CatAdmin

I have this SP but i need some SP which retrieves the Username and the Priveleges.
Eg User A has Read And Write Privelege

Regards
Sen

 

[SQLBill]

Check out SYSPROTECTS table. Look it up in the BOL, I think that has what you want. Also look up sp_helprotect. (there is only one P in that command).

-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

Also, sp_helpusers can give you the user name and userid (the two commands in my previous post only return the userid and not the name).

-SQLBill

Posting advice: FAQ481-4875