How could I find a list of who has write access within my SQL2K5.
ThanksOn Apr 25, 12:06=A0am, "OA" <omr...@.verizon.net> wrote:
> How could I find =A0a list of who has write access within my SQL2K5.
> Thanks
Hi ,
You can use below commands for your requirement.
Run these procedure under the database for which you need the privs
info.
sp_helprotect
sp_helplogins
sp_helprolemember
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment