creating schema in oracle sql

on
creating schema:-

CREATE USER USER_NAME IDENTIFIED BY PASSWORD;
GRANT ALL PRIVILEGES TO USER_NAME;
GRANT DBA TO USER_NAME;



in above schema we have to give for name for user_name and password
for example 

CREATE USER source IDENTIFIED BY abcd;
GRANT ALL PRIVILEGES TO source ;
GRANT DBA TO source ;


here user_name or schema name is source and password for this schema is abcd.


















































































































































Comments

Post a Comment