-
Hi,
I have a problem with the management of permissions.
I have UserA and UserB.
UserA owns a table T.
UserB can select the table T of UserA.
Now I want to allow UserA to create a view in
the schema of UserB.
How can I do it without using:
grant create any view to UserA
Thanks in advance
Olaf Oelsner
-
Why do you want user-A to create view in user-B ? Any specific reason ? If user-B can select table from user-A, user-B can create view right ? (Assuming User-B has privileges to create view). Am I missing something here ?
Reddy,Sam
-
I want that UserB is allowed to update the view of UserA.
-
So, grant UserB - UPDATE priv on UserA's T. And if UserB has the create view priv, everything should be okay....
Why a view ?
svk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|