You grant the user privileges. The user you want to grant permissions must have a valid unix account on the server.
To allow a user to connect to database. As owner or dba of the database issue:
To allow user to run queries on specific tables. As owner of the table or as dba user issue:
Where: table is the table you want to grant permission to. userid is the user account you want to grant permission to. owner-of-table is the owner of the table you are granting permission to. Use dbschema to determine owner if do not know. database is the database the table resides in.
NOTE: If the table has PUBLIC privileges, the second step is not necessary. (dbschema will show) NOTE: Other abilities such as insert, delete, update can be added in the same manner as the second step. Substitute "select" with desired action.
Dbschema format:
This will show the dbscheme for all components of database: dbschema -d database -ss Where: database is the database.