oracle11g - oracle 11.2.0 - create or replace synonym privilege for a user -


in oracle 11.2.0 if grant create synonym user , mean use has create or replace synonym privilege or create synonym privilege?

there no special system privilege 'grant create or replace' in oracle rdbms. when granted 'create synonym privilege', user able use both create synonym create or replace synonym syntax. check oracle documentation more info.


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -