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?