sp_helpuser

Question

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

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

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 1

Hi

Pls use this query

SELECT * FROM dba_users ORDER BY CREATED DESC

or

SELECT * FROM dba_users WHERE username LIKE 'xxx%' ORDER BY CREATED DESC;

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 2

Hi

also go thru this link, if required:

krypto69 SSChampion Points: 13604 More actions · Answer 3

SSChampion

Points: 13604

December 15, 2010 at 7:41 am

dba_users?

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 4

Yes..

The user executing that should have the grant privileges...

krypto69 SSChampion Points: 13604 More actions · Answer 5

SSChampion

Points: 13604

December 16, 2010 at 8:42 am

dba_users is not a table...?

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 6

Hi

If you want database users then sp_helpusers will give them. If you want

logins then sp_helplogins will list them.