Translate

9 Eylül 2014 Salı

CREATE USER FOR ORACLE DB


I have created a.sql file with text -->

CREATE USER myuser IDENTIFIED BY mypassword
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;

C:\Windows\System32> sqlplus

enter user-name: system
Enter password: hr (yourpassword)

SQL> cd @C:\Users\computer\Desktop\a.SQL

user created;

SQL> GRANT CREATE SESSION TO myuser;

Grant succeeded


C:\Windows\System32> sqlplus
enter user-name: myuser
Enter password: mypassword

SQL>  :P

Hiç yorum yok:

Yorum Gönder

Bu Blogda Ara