Forum Post: RE: how to grant user using sqlexp

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
this is what i have used in some of my scripts for UNIX and Linux (requires that a server be started first. SQL cannot be used in single-user mode): sqlexp ${DB_NAME} -S ${DB_PORT} -HERE_EOF create user '${DB_USERID}', '${DB_PASSWORD}'; grant dba,resource to '${DB_USERID}'; commit; quit; HERE_EOF to give somebody just read access, you grant them the SELECT privilege on a table.

Continue reading...
 
Status
Not open for further replies.
Back
Top