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