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:
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.
This will show the dbscheme for all components of database:
dbschema -d database -ss
database is the database.