1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to deny drop table permission for an user

Discussion in 'Security, Backup and Recovery' started by haraprasad, Jun 16, 2009.

  1. haraprasad

    haraprasad Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I am new to oracle, I have created a new user under that i have created some tables where in i don't want to any user should use drop table command. what to do ?
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Simple .

    Grant only Create / Select privilege to other users. And dont give Drop table / DBA privilege to them.
     
  3. haraprasad

    haraprasad Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    Thanks for ur reply