September 30th, 2011, 10:14 AM
I have an automated process which runs on an Oracle 8i database server as user abc.
This process creates views/tables in other schemas, on the same database server, which point to objects owned by the abc user.
The issue I'm getting is that when I try to execute GRANT SELECT ON xyz.view123 TO PUBLIC as the abc user, I get an insufficient privileges.
I should add that the abc user created the xyz.view123 table/view.
What grants/priviliges or whatever do I have to do to the abc schema?
November 15th, 2011, 02:13 AM
if the abc user have DBA privileges, you can give the GRANT PRIVS
November 17th, 2011, 06:10 PM