How to display database privileges
Posted in 2000
Topics: Stored Procedures & SPL
I want to see the CONNECT and other database-level privileges, but all I can find are table-level privileges (systabauth, dbinfo etc.). Is there a way? --Micha
Hi Micha.
select * from sysusers -- for database-level privileges
Good luck.
Sergey.
Micha <none@nowhere.net> ''''' ' ''''''''':39F69A09.3833B29D@nowhere.net...
> I want to see the CONNECT and other database-level
> privileges, but all I can find are table-level
> privileges (systabauth, dbinfo etc.). Is there
> a way?
>
> --Micha
In article <39F69A09.3833B29D@nowhere.net>, Micha <none@nowhere.net> wrote: > I want to see the CONNECT and other database-level > privileges, but all I can find are table-level > privileges (systabauth, dbinfo etc.). Is there > a way? > > --Micha > Hi Micha, Database level privileges are stored in table sysusers. Sent via Deja.com http://www.deja.com/ Before you buy.