DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2001

    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.




  2. #2
    Join Date
    Dec 1999
    Cincinnati, Ohio USA
    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.

  3. #3
    Join Date
    Nov 2000
    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
    Ljubljana, Slovenia
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.