Wednesday, June 3, 2015

Granting Views access to a Schema User.


When granting view access to a schema user on 11g database.I tried giving select on to a particular views.But it raised me an error.So  I used  "select_catalog_role" privilege.That works fine for me.

grant select_catalog_role to lahiru;



 :)




No comments:

Post a Comment