Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: user access to create tables

Re: user access to create tables

From: Martin Doherty <martin.doherty_at_undisclosed.com>
Date: Wed, 25 Jan 2006 12:29:26 -0500
Message-ID: <uQOBf.32$Lf1.62@news.oracle.com>


DA Morgan wrote:

> PK wrote:
>
>> You can also do 'Grant connect, resource to <user>'. This will give
>> them the privileges needed.
>>
>> Prashant
>
>
> And destroy any concept of security. Why would you grant someone
> the privilege to build clusters and database links when all they
> want to do is create tables?

Note the context of the OP request, it's a DB class (probably beginners). There is no data to secure (unless the teacher is keeping test scores in there) and the instance will probably be dropped after the class, so the over-granting of privileges in this context is hardly a problem and possibly a help. Obviously students should not receive privileges to allow them to SELECT ANY TABLE or DROP ANY USER, since that could actually permit cheating or disrupt the progress of the class.

Martin Received on Wed Jan 25 2006 - 11:29:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US