Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

Now our next task is assigning rights, since we like to register the user learner as administrator, developer and application user, we are authorizing by minimal three rights as connect, privilege to get connected with database, and to use all the resources of oracle-APEX and   as   database   administrator.    Since    database administrator can create many user with restricted rights of developing using the application.

Now type in the sql prompt as

 

SQL> Grant connect, resource, dba to learner; Grant succeeded message will be displayed. Type Exit and come out of SQL prompt.

Meaning of these commands and usage will be seen on later part. Temporarilyou understand that you have created user as learner and the password is learner.

Now we shall enter into Apex environment: