Re: Grant command questions
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Tue, 28 Mar 2006 15:38:38 -0600
Harvinder,
Take a look at GRANT SELECT ANY.
Unfortunately that doesn't restrict them to just USER2.
Why not grant access when the table is created? You don't need access before
the table is created.
You could create a stored procedure that User2 could call for all access.
That s.p. would be owned by user1 and therefore would have access to any
tables User1 owned.
Dennis Williams
On 3/28/06, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote:
>
> Hi,
>
>
>
> We have a schema named User1 that owns all the objects of the application.
> Now we need to create 3-4 dynamic schema's User2-User5 that will have about
> 10 tables each and we want to give full access on these tables to User1.
>
> Is there any way that when we create User2 that we can give complete
> access on all its objects (not yet created) to User1? (we can't give DBA
> role to User1)
>
>
>
> Thanks
>
> --Harvinder
>
>
>
Other related posts:
