Select user table privileges
Could you tell me the statement to do the following: Select all tables and privileges that a user has
Table level privileges:
select * from systabauth where grantee = 'myname';Column level privileges:
select * from syscolauth where grantee = 'myname';
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Nov 18, 2009 at 11:25 AM, STEPHEN LIDDLE <
stephen.liddle@assetcods.com> wrote:
> Could you tell me the statement to do the following:
>
> Select all tables and privileges that a user has
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00151747afcc1912890478a83bd3
Don't forget PUBLIC privileges:
Table level privileges:
select * from systabauth where grantee = 'myname' or grantee = 'public';Column level privileges:
select * from syscolauth where grantee = 'myname' or grantee = 'public';
Then there are other privileges - like fragmentation privileges. However,
they're obscure enough not to matter for most purposes.
On Wed, Nov 18, 2009 at 09:04, Art Kagel <art.kagel@gmail.com> wrote:
> Table level privileges:
> select * from systabauth where grantee = 'myname';> Column level privileges:
> select * from syscolauth where grantee = 'myname';>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Nov 18, 2009 at 11:25 AM, STEPHEN LIDDLE <
> stephen.liddle@assetcods.com> wrote:
>
> > Could you tell me the statement to do the following:
> >
> > Select all tables and privileges that a user has
>
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Jonathan Swift<http://www.brainyquote.com/quotes/authors/j/jonathan_swift.html>;
- "May you live every day of your life."
--000e0cd296946387c5047926b8a4