Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sql Help granting roles /privileges to users

Sql Help granting roles /privileges to users

From: Tyler Smith Watu <watuni2000_at_yahoo.co.nz>
Date: 18 Feb 2004 07:16:13 -0800
Message-ID: <2f3438a4.0402180716.6ce6fe66@posting.google.com>


unix hp oracle ver 8.1.7.4

I am working on a script that I will use to recreate users

The part that I need help on will be the script to grant user privileges

The output should be a file containing statements like this

grant connect to jpajim;
grant resource to jpajim;

Thanks for your time

TY Received on Wed Feb 18 2004 - 09:16:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US