-
Granting select privileges on synonym
Dear all,
Here is my situation. I am creating synonym for the table which is in Remote database. Synonym creation is successful. After that, i am granting select privileges on synonym to other schema's in the same database. How do i resolve this.
I can create the same synonym in all other schema's. But i do not want that.
SQL> CREATE SYNONYM gt_ausp FOR infsapi.AUSP@odsprd_i_box;
Synonym created.
SQL> GRANT SELECT ON gt_ausp TO raventst
2 ;
GRANT SELECT ON gt_ausp TO raventst
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database
SQL>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|