Showing posts with label Create a user and grant connect and execute. Show all posts
Showing posts with label Create a user and grant connect and execute. Show all posts

Tuesday, 26 July 2016

Create a user and grant connect and execute

CREATE USER username IDENTIFIED BY apassword;

GRANT CONNECT TO username;

GRANT EXECUTE on schema.procedure TO username;

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...