Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restrict access of table/views in APEX based on users.

DeepakJSep 3 2009 — edited Sep 3 2009
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2009
Added on Sep 3 2009
5 comments
611 views