To connect rest of the computer with a server controlled by only DBA (Database Administration)

DBA's role: One source, database controller

Purpose :

 To connect the rest of 

the computer with a server controlled by only DBA 

Step 1

Step 1 

 

Step 1 

1. Create a personal account by using of sys 

2. Sys is a basic account assigned when we create an account in SQL 

3.  The basic sys SQL file will be saved D drive 

 Order sentence in worksheet 

Create user  (ID)

Identified by “  “

Default tablespace users

Quota unlimited on users;

Grant creates session to (ID)

Grant source to (ID)Grant connect to (ID)

Step 2 

1. DBA Connect with other computers and server
2. Connect with the other computer using of order sentence and grant authorization with resource/connection 
3. DBA will make a final connection with the server by pushing a Green + button         

4. A new database connection needs an account (newly created) and a unique IP number to connect with the server. 

 Order sentence for 2-2

Create a user (ID)

Identified by “ “

Default tablespace users

Quota unlimited on users;

Grant session to (ID)

Grant source to (ID)

Grant connect to (ID)