granting privilages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: granting privilages

  1. #1
    Join Date
    Nov 2001
    Location
    Bangalore
    Posts
    41
    Hi,

    Here i have 2 questions -

    1) how do i grant privilages like select, delete, update, insert to user b on user a schema.
    suppose if i have 1500 tables then i should give all the permissions to the user 'b' of only user 'a' schemas with out generating a script.

    for ex:
    select ' grant ' .......

    here if u do like this there will be a problem.
    if u create a new table then explicitly we need to give the permissions.

    Can some one tell me at one shot how we can grant the privileges.


    2) Yesterday i have created a database user by giving
    default tablespace and temporary tablespace . I was getting error and if i mention quota then it is working. I don't know the reason why it is getting error if i don't mentioned the quota. the default is unlimited so it should not thow any error.


    Cheers

    sanjay

    san

  2. #2
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    1) You can not grant rights to another user's object in 7x or 8x, it is possible in 9i!

    2) Need the error if you can get it.
    Doug

  3. #3
    Join Date
    Nov 2000
    Posts
    224
    Logon as a and generate the script using,

    select 'grant select,update,delete, insert on '||table_name||' to b;'
    from USER_TABLES;

    now run this script while logged on as a.

    Better create role and grant these permissions to role and then grant this role to user b or anyone else as required.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by molonede
    1) You can not grant rights to another user's object in 7x or 8x, it is possible in 9i!
    This has nothing to do with 9i - granting privileges on another user's objects is available at least since Oracle 6.0!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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