On Tue, 10 Apr 2007, damorgan_at_psoug.org wrote:
> Michael42 wrote:
>> Hello,
>> In an Oracle 10g R2 database I created a user with CONNECT and
>> RESOURCE roles. They can create their own tables in their schema but
>> not views. What priviledge is required for a user to be able to
>> create a view?
>> Thanks,
>> Michael
>
> It is a bad policy to grant CONNECT and RESOURCE.
>
> grant CREATE SESSION, CREATE TABLE, CREATE VIEW, etc. explicitly
> and only as required.
And usually it is good practice to grant privileges to a role then grant
that role to different users.
--
Galen Boyer
Received on Tue Apr 10 2007 - 21:33:02 CDT
