Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Grant listing - howto

Re: Grant listing - howto

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 15 Oct 1999 09:08:02 -0400
Message-ID: <7u7a2b$hdo$1@autumn.news.rcn.net>


Hi,

    Look at the view TABLE_PRIVILEGES, e.g.

        SELECT * FROM table_privileges;

regards
jerry gitomer

torgeir wrote in message <380713CB.4131DBD0_at_sverige.se>...
>Hello.
>
>A newbee question:
>What's the easiest sql*plus command to check or list grants
>that have been set?
>
>Thanx in advance
>
>Regards
>
>Luni Gammelmoen
Received on Fri Oct 15 1999 - 08:08:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US