Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: user access to create tables
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