Grant create session to user;
grant insert,select,delete on table_name to user;





"Amin Adatia "
<oracledba-ezmlms
hield-x86066459.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
06/03/2007 09:55
Subject
Re: how to grant a user no right to
create a new table in Oracle










Which version?

Just grant connect to the user ... or just CREATE SESSION

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Linus Li " <oracledba-ezmlmshield-x2025814.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, March 05, 2007 12:22 PM
Subject: how to grant a user no right to create a new table in Oracle


> Could anybody please tell how to grant a user no right to create a new
> table in Oracle?
>
> Linus
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





The information in this e-mail and any attachment(s) here to is only for the use of the intended recipient and may be confidential or privileged. If you are not the intended recipient, any use of, reliance on, reference to, disclosure of, alteration to or copying of the information for any purpose is prohibited. Any information not related to BNM's official business is solely the author's and does not necessarily represent BNM's view and is not necessarily endorsed by BNM. BNM shall not be liable for loss or damage caused by viruses transmitted by this e-mail or its attachments. BNM is not responsible for any unauthorised changes made to the information or for the effect of such changes.

Oracle LazyDBA home page