Re: Role's privileges

From: Eric Givler <egivler_at_flash.net>
Date: 2000/07/27
Message-ID: <S9Zf5.2857$ck.299592@news.flash.net>#1/1

select * from role_tab_privs?
select * from role_sys_privs?

If it's a role that wasn't created by you, then you'd probably have to go against sys tables (just guessing)

Paul <paulhjli_at_hotmail.com> wrote in message news:so0lbtj53j1150_at_corp.supernews.com...
> Hi,
> Could someone tell me the SQL command to know the object and system
> privileges for the role, such as CONNECT or roles created by me.
>
> Thanks
>
> Paul Li
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Thu Jul 27 2000 - 00:00:00 CDT