How to get a list of all users with sa privilege?

Question

Post reply

How to get a list of all users with sa privilege?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
November 7, 2006 at 8:36 am

#69437

I mean how to get a list of all users with sa privilege, not manually?

Viewing 10 posts - 1 through 9 (of 9 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

USE master

SELECT name FROM syslogins WHERE sysadmin = 1

John

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

Thank you for your input. It works. A weird result was found when I run

SELECT * FROM master..syslogins WHERE sysadmin = 1

Look at the value at sysadmin!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

And now you have a proof... 1 = 0. Looks like those users were right all along .

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

I have not finished my coffee yet ... what am I missing here ?

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

SELECT * FROM master..syslogins WHERE sysadmin = 1

Check out the third line >> SysAdmin = 0

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 6

I just spot checked 4 of my 25 servers and did not find Sysadmin=0 in the query results ...

I'm on my second cup of coffee as well ...

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

Must have been fixed with a Service pack... can't say I installed of 'em on my dev machine !

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 8

My SQL version is 2000 (8.00.2039). When I used grid for output, I found the weird output. When I used text for out, everything was going fine.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 9

Very interesting ... I have been able to duplicate it when using grid for output instead of text. It only occurs for SQL logins with the sysadmin role, not NT logins. I am on 8.00.818 across the board (SP3 w/hotfix 818).

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."