Hey All,
I've gone thru some of the documentation over at Oracle about creating
a user:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm

CREATE USER jward
    IDENTIFIED BY aZ7bC2
    DEFAULT TABLESPACE data_ts
    QUOTA 100M ON test_ts
    QUOTA 500K ON data_ts
    TEMPORARY TABLESPACE temp_ts
    PROFILE clerk;
GRANT connect TO jward;

And this all looks like it makes sense, however,  I don't see where I
would specify read only access..

Say I wanted my user to have total access across all schemas to be
able to pull any data down, but it can only have read access across
them all, what would the SQL Look like?

Thanks,

~Dan

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to