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

Thread: Reg :- Priviledges

  1. #1
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Post

    Hi Guys

    I have a problem in assigning the priviledges to a user

    I have create a user EEIuser and i wanna give rights only to connect and create table not drop table.

    But when i have given create session,create table priveldge its allwoing me to connect and create table but its allowing me to drop also the table which i didnt give the user the rights.

    How to restrict the user from giving not to drop table priviledge becauz theni grante the drop any table priviledge and revoke still its allwoing me to drop table

    Am using oracle 8i

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    When you give a user CREATE TABLE privelege that user will be able to DROP the table as he is the owner of the table.If you want to restrict the user to drop the table you can write a schema level trigger which will restrict to drop the table and this is possible in Oracle 8i

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Aug 2001
    Location
    Dubai
    Posts
    41

    Thanks Rohit

    Can you help me in this to write a trigger

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