RE: CREATE VIEW PROBLEM

Cause: An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.

  Action: Grant the required privileges to the user directly

Access to the table(s) used in the view must be granted directly to the users of the view. See message explanation above.

> -----Original Message-----
> From: Jimmy [SMTP:c6635500_at_comp.polyu.edu.hk]
> Posted At: Saturday, February 20, 1999 3:10 AM
> Posted To: comp.databases.oracle.server
> Conversation: CREATE VIEW PROBLEM...
> Subject: CREATE VIEW PROBLEM...
>
> Hello all,
> When I create view as "create view tmp_view as select * from
> AAA", an
> error message, "ORA-01933: cannot create a stored object using
> privileges from a role".
>
> Why such an error message was shown and how can I solve this
> problem?
>
> Thanks,
> Jimmy
Received on Fri Feb 19 1999 - 10:37:49 CST