User2 Creates Tables for User1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: User2 Creates Tables for User1

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    How can I grant a privilige to User2, so he can only create tables for User1?

    I know there are CREATE TABLE and CREATE ANY TABLE system privileges, but CREATE TABLE privilege is for creating tables for own and CREATE ANY TABLE is for creating tables for any one else, not for a particular user.

    Thanks.
    zm

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    USER1 should create a PL/SQL procedure that creates a table (using dynamic SQL). Then he grants the EXECUTE on this procedure to USER2 - now USER2 can create tables under USER1's schema, while other users can't, unless they have CREATE ANY TABLE privs.

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Posts
    109
    Thanks for the reply.

    I am totally new to Oracle (acturally new to database too). It will be great if you could show me what scripts look like.

    I really appreciate your kind help.
    zm

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