Re: Permissions required for create materialized view dynamically

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:1pdhs0h5m8p5d49tc7pfs1fla1iu1r3p25_at_4ax.com...
> On Tue, 21 Dec 2004 23:49:55 GMT, "Jack Addington"
> <jaddington_at_shaw.ca> wrote:
>
>>As soon as I do a set role none; then I can't do anything. I get
>>insufficient privs.
>
>
>
> Which just exactly shows you don't have direct privs, but you have all
> your privileges through roles.
> To see which they are, reconnect, and issue select * from
> session_privs
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

ok when I first logged in I had 140 privs. I ran set role none; re-ran it and I had only 2

(CREATE SNAPSHOT
UNLIMITED TABLESPACE) Received on Tue Dec 21 2004 - 17:58:49 CST