DBA priveleges(funny scenario)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBA priveleges(funny scenario)

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    DBA priveleges vanished

    Hi Gurus,

    I performed an import of 4 users into a database.
    Now, in those four schema's, even DBA has no priveleges even though the priveleges show up.
    For example I am unable to compile and SP even logged on as SYS!

    Any ideas on this?

    Thanks!
    Last edited by hemanr; 08-07-2003 at 02:52 PM.
    Hemant

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you have the schema owner created before you imported? What kind of import did you do?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Sam,

    3 users did not exist in the new database. Yes I created the users.
    One of the users already existed with no objects.

    This was an import by individual user from the dump, using Fromuser and Touser.

    I have also found that one of the users imported has no privileges on its own objects!
    It has no privileges on a view owned by itself!

    Any ideas?
    Hemant

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Find out who the owner of the object is from dba_objects table. Then check what all privileges that user has. There must be some user who has privileges on these objects. Also check what were the privileges for that user in old database.
    -- Dilip

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