STEPS
1. login into "sql developer" with user: sys role:sysdba
2. click on connection "sys" and view all objects
3. select "other user" from sys user
4. now create new user with privileges
5. provide user name & password
6. select "system privileges" tab from create user and select
CREATE SESSION - connect database
CREATE TABLE - it enable user to create table
7. connect to newly created user by using command prompt.
in cmd prmpt type "sqlplus" it recommended for username:ajayaj and password:***** 8. create a new table
9. dropping user first disconnect the created user from cmd prompt by "quit"
10. open sql developer and browse other user from sys
11. select the user which we created and right click on it then select drop user with click checkbox: cascade
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon