DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: System Privilege

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Hi, All
    We have an application user who was granted all privileges.
    This user owns the application therefore all other users were created under its schema.
    The same application user is created on production and test database.
    When you logon the production database with that user and password you can create other users and grant privilege with no
    problem.

    BUT
    when you try to create other users with the same application user
    on the test database we are getting ORA-00990- Missing or invalid
    privilege.

    We compared the privileges of the two databases and we find out that the Test database has the following privileges granted

    ADMINISTER RESOURCE MANAGER
    ALTER OPERATOR
    DEQUEUE ANY QUEUE
    ENQUEUE ANY QUEUE
    EXTENDS ANY TYPE
    EXTENDS TYPE
    MANAGE ANY QUEUE.

    The above privileges are not on the production database therefore NO problem with creating users on the Production.

    We are a little skeptical in droping the application user on the TEST database and recreate it.

    We also attemped to revoke those privileges and getting the same error. (Invalid or missing privilege)

    What 's the reprecaution of login as INTERNAL and drop the application user cascade that owns all the tables & recreate it ?
    Please advise

    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The user will be dropped with allits objects.

    But I don't think you need to drop that user to resolve this. Just make sure the user has all the required roles and system privileges.

    Sanjay

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    SANJAY
    Thanks for the prompt response.
    I checked the DBA_ROLE_PRIVS and GRANTED_ROLE for the application user on both production and test and the result is the same.

    SQL> select granted_role from dba_role_privs where grantee ='application_user_name'

    PRODUCTION GRANTED_ROLE = A B C

    TEST GRANTED_ROLE = A B C

    Any other suggestion?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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