Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create User
create user <name> identified by <password> default tablespace <tablespace> temporary tablespace <tablespace>;
2. Log in as each owner of the table you wish to give only select access. As this user:
grant select on <table name> to <name>;
If there are a lot of tables, scripting works best. Received on Sat Jun 15 2002 - 10:46:15 CDT