[SGVLUG] Database security for "sql" databases

[Robert Leyva]

Usually a DB will have some internal tables where this type of 
information exists.

In postgres, for example: "select * from pg_stat_user_tables;" would 
list out all the tables and their schemas.

We just have to figure out what the internal table names are for where 
such info is stored in your db.


Me


Emerson, Tom wrote:

>I'm trying to determine and/or validate that the proper permissions have been "granted" to the proper people for a particular SQL database, and, well, I'm running into "difficulties".
>
>I don't know if this is true of "sql databases" in general, or just the one I'm using.  From the interactive SQL / query utility supplied by the vendor, I see I can issue "GRANT..." commands to allow other users and entities access (or REVOKE to remove those access rights)  What I cannot find is any command to REVIEW the current access rights.
>  
>

-- 
---
"Knowledge is Power." -- Francis Bacon

Robert Leyva 
(Robert.Leyva at warnerbros.com)
Software Engineer
Warner Bros. Online