I created a user that needs read only access to a database. I created this user with the default tablespace that is needed. I granted the CONNECT role to him as well as CREATE SESSION.
When the user connects via SQL Developer and clicks on the + sign in front of the Tables it comes back empty. The user is able to see the contents of the table with a select statement as long as it is prefixed by the TABLESPACE name, i.e.
SELECT * FROM DM.table
I am sure I am missing something simple, a grant statement more than likely. Can someone help me out please.
Much Thanks
When the user connects via SQL Developer and clicks on the + sign in front of the Tables it comes back empty. The user is able to see the contents of the table with a select statement as long as it is prefixed by the TABLESPACE name, i.e.
SELECT * FROM DM.table
I am sure I am missing something simple, a grant statement more than likely. Can someone help me out please.
Much Thanks