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

Thread: What happened?

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    I granted one of the database users resource a long time ago. And I've never revoked it. But now the user can not create tables any more. The error message is: Insufficient privs.

    What could possibly happened?

    Thanks!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What, exactly, is the statement and the error message they are receiving?
    Jeff Hunter

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    Look at user_tab_privs and user_sys_privs for the user. If someone revoked your 'GRANTABLE' option, the user to whom you granted privileges would lose them also.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Jun 2000
    Posts
    315
    The exact error and message is: ora-01031:insufficient privileges.

    Nobody else except me has dba privs.

    Thanks!


  5. #5
    Join Date
    Aug 2000
    Posts
    236
    Problem's nothing to do with your DBA privileges.

    If resource has not been revoked check to see if the user has not exceeded the quota allocated to him on the DB and the TS still has free space.

    Nizar

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Originally posted by Nizar:
    If resource has not been revoked check to see if the user has not exceeded the quota allocated to him on the DB
    Just to straighten up things here, Nizar, in that case the error would be:
    ORA-01536: space quota exceeded for tablespace 'USER_DATA'



    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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