CODEWITHSUNDEEP
oracle-databaseoracle11goracle10g
tweeper
tweeper

Reputation: 352

oracle 11.2.0 - create or replace synonym privilege for a user

In oracle 11.2.0 if we grant create synonym to a user , does this mean the use has create or replace synonym privilege or only create synonym privilege?

Upvotes: 0

Views: 761

Answers (1)

Erik Janssen
Erik Janssen

Reputation: 1

There is no special system privilege 'grant create or replace' in Oracle RDBMS. When granted the 'create synonym privilege', the user will be able to use both the CREATE SYNONYM as well as the CREATE OR REPLACE SYNONYM syntax. Check the Oracle Documentation for more info.

Upvotes: 0

Related Questions