1 Reply Latest reply: Jan 22, 2013 7:20 AM by IBarr RSS

    how can i create a user who does not have the access public role group

    982623
      Actually in our database some privileges are assigned like below:

      GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON scott.emp TO PUBLIC;
      Now I have created a user

      SQL> create user ab identified by ab default tablespace ins quota unlimited on ins account unlock;
      sql>grant connect,create session ,select any table to ab;
      sql> conn ab/ab@demodb
      sql>select * from scott.emp;

      All the record are showing here.
      If I Run the below query then the record are not showing ...

      sql>revoke ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK on scott.emp from public;

      I do not want to revoke the privileges from public.
      My Question is Can I create a user who does not access the public role group?