Restrict access of table/views in APEX based on users.
DeepakJSep 3 2009 — edited Sep 3 2009I am have the following..
1. Workspace - WRS1
2. Schema - SCH1
3. Schema consist of, suppose 10 tables - table1, table2, ..... table10
Now I want to restrict the access of tables based on the APEX user.
Suppose user1 logins - he should have the access of table1, table2 only, I mean when he go to SQL Workshop>Object Browser he should able to see only table1 & table2
user2 logins - he can have the access of tabl1, table2 & table3 only through SQL Workshop>Object Browser ....and so on....
My question is, can we restrict the table level access for APEX users through SQL Workshop>Object Browser OR when we do SQL query using SQL Workshop>SQL Commands
Thanks,
Deepak