Re: Privileges
Date: 1995/12/12
Message-ID: <4akped$s1e_at_inet-nntp-gw-1.us.oracle.com>#1/1
stauffer_at_swarthmore.edu (stauffer) wrote:
>Running into a problem on a new, vendor-installed database and my mind has
>Here is the error I get when a user tries to create a view:
>ERROR at line 4:
>The user has the dba role and was granted 'create view' explicitly.
The dba user could have the create view privelege from a role.
What they need is direct access to the underlying objects. For example, if you
dba wanted to
create view my_emp
>gone blank...
>ORA-01933: cannot create a stored object using privileges from a role
as
select * from scott.emp
/
Scott would have had to issued:
grant select on emp to ThatDbaAccount
/
>So, what am I missing?
>Thanks,
>Glenn Stauffer
>To get random signatures put text files into a folder called ³Random Signatures² into your Preferences folder.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Received on Tue Dec 12 1995 - 00:00:00 CET