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