Skip navigation
ANNOUNCEMENT: is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.

CREATE easily Database Link for another user

score 550
You have not voted. Active

Every time I am asked to create a link to another DB schema is the same headache. Sometimes I use the dbms_sys_sql.parse_as_user to execute the create code as the other user. I need to give the user the CREATE DATABASE LINK system privilege, execute the action and than revoke it back. Things get even worse when I'm on a Database Vault enabled DB.


Why Oracle does not simplify the things with a SYNTAX like:




Please Oracle, give me that syntax! =]




Rodrigo Jorge


Vote history