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

Home -> Community -> Usenet -> c.d.o.server -> Re: Permissions required for create materialized view dynamically

Re: Permissions required for create materialized view dynamically

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Wed, 22 Dec 2004 00:53:09 +0100
Message-ID: <1pdhs0h5m8p5d49tc7pfs1fla1iu1r3p25@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


Received on Tue Dec 21 2004 - 17:53:09 CST












Original text of this message













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