Re: DBA - Question - USER privilegs

1. Create a user that can not create tables in their default tablespace SQL> create user myuser identified by mypassword temporary tablespace temp default tablespace users;

grant connect to myuser;

2. as the owner of the object, grant privs to myuser. SQL> grant select on mytable to myuser

3. as the owner of the procedure/function, grant execute to myuser SQL> grant execute on myfunction to myuser

Note: You must explicitly grant permits to the user and not to a role to execute stored procedures using dynamic sql. Received on Tue Aug 24 1999 - 21:39:11 CDT