Re: Create User

1. How to 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