Adding a user to have access to a table in my schema 1

[evergreean43]

Currently I have a Schema in my Oracle 9i database with the name of dbdata where I log in such as:

sqlplus dbdata/dbdataPassword@myserver/aaa

I would like to allow another person to be able to access a table in my schema and select and update information on that table (called dept). Do I create another user to have access to tables in my schema?

After I log into my schema I can do these commands?

create user Smith identified by SmithPassword; 

GRANT SELECT, UPDATE ON dept TO SMITH;

Then "Joe Smith" can log into the schema:

sqlplus Smith/SmithPassword@myserver/aaa


Please advise.

 

[LKBrwnDBA]

Yes.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: You may need to grant at least CONNECT (or create session) to smith.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[evergreean43]

Thanks for quick response.

Can you advise SQL for granting CONNECT and CREATE SESSION?

What is difference? I only want the user to touch one or two tables in my schema called dbdata.

 

[LKBrwnDBA]

CONNECT has CREATE SESSION privilege.

GRANT CONNECT TO SMITH;


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[evergreean43]

Thanks!