I am a little rusty but wouldn't granting "select any table" to the user work if what you REALLY want is to see all data irrespective of schema?
Rob On Nov 16, 5:00 pm, DanRegalia <drega...@gmail.com> wrote: > 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