Grant create view in a schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Grant create view in a schema

  1. #1
    Join Date
    May 2001
    Posts
    8
    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  3. #3
    Join Date
    May 2001
    Posts
    8
    I want that UserB is allowed to update the view of UserA.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    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
  •  


Click Here to Expand Forum to Full Width