Object Level Permissions

Question

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

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

nmoore SSCrazy Points: 2414 More actions · Answer 1

You could use SQL DMO.

Nigel Moore
======================

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

sp_helprotect

Returns a report with information about user permissions for an object, or statement permissions, in the current database.

d_george SSCrazy Points: 2462 More actions · Answer 3

Hi

Thanks.

I don't know anything about SQL DMO, how do I use that?

The procedure worked great; but now how can I find out what users are assigned to a group?

Thanks

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 4

quote:
how can I find out what users are assigned to a group?

Are you talking about server/database roles? If you are, use sp_sp_helprolemember, sp_helpsrvrolemember.

If you want to know who is in NT group, ask your NT administrators.

Steven. SSCrazy Eights Points: 9806 More actions · Answer 5

If you are running sql 2000 enterprise manager, you can find out who is in an nt group via EM

go to add a new login.

click on the ... next to the name

find your group, and press the members button

Regards

Steven

d_george SSCrazy Points: 2462 More actions · Answer 6

Howdy

Thanks everyone. Great tips, I appreceate all the help.