on 09-26-2013 11:23 AM
Hi,
We are facing the following issue - some user seems to have added _SYS_BIC schema to the PUBLIC role.
As a consequence, package level authorisations are not working. Users are able to view and consume packages created by other users which they are not suppose to.
Upon trying to remove the _SYS_BIC schema from the role, the system puts it back. This happens even if the deletion is done with SYSTEM user.
Pl advise how can this be resolved. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
Make sure that those users do not have system privilege ROLE ADMIN.
First remove this privilege.
There is also a chance that the same privilege (_SYS_BIC) added to more than 1 role and the user might have one of those roles.
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.