Re: Grants for Views

No. These roles are not sufficient to do this. There are a few points to consider in this model. In order for a user to create/view/delete views he must have privileges on the base objects. If these have not been predefined you could end up with a user who has create any view, drop any view and select any table privileges - not a good idea!

The best way to do what you need is to create a stored procedure as user 2 and use this to create the view and grant the necessary delete/select privileges to user 1. User 1 then only needs execute privileges on the procedure. This of course assumes that user 2 has the necessary privileges to create the view.

As a matter of interest; why do you need to create the view in another schema?

hth
Anthony Hogan
ahogan-nospam-_at_iespana.es

Fabienne Hadek wrote:
>
> Thank you very much!
> But now, if I want one user to be able to create, view and delete views in
> another user's schema and the first user does habe the connect and resource
> roles, is this enough or do I have to explicitly grant those rights to him?
> The explanations in the oracle-documentation on this topic seem quite
> confusing.
> Fabienne
Received on Thu May 23 2002 - 08:02:08 CDT