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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
