Saturday, January 7, 2017

Grant DBA rights to specific user

$ sqlplus

SQL*Plus: Release Production on Sat Jan 7 13:52:22 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant dba to availabilityuser with admin option;

Grant succeeded.

No comments:

Post a Comment