Do you add a policy in oracle db for simulate a virtual db?
Ok! the
dbms_rls.add_policy function do it for you!
Buuuuut, one moment please!
Do you have the two rights?
1) Privilege rights?
2) DB rights (Enterprise Edition)?
The first, you can get it from sys user, executing this grant:
GRANT EXECUTE ON dbms_rls TO YOUR_USERThe second one, you can get it only if you have the right oracle db version. Don't you know if your versione is Enterprise? ok! this is the query for to know the version of your oracle db:
select * from v$versionUhm! Don't you understand if the db is standard or enterrprise?
OK! the following query can says you if you have the function for add policy:select * from v$option where parameter like 'Fine%';
if true then
you can add policy
else
YOU CANNOT add policy
if you can't add policy you'll get this error:
ORA-00439: function not enabled: Fine-grained access control
OK?!