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: how to stop user from altering schema

Re: how to stop user from altering schema

From: nirav <shivam71_at_gmail.com>
Date: 9 Jun 2005 06:35:05 -0700
Message-ID: <1118324105.280015.55990@g49g2000cwa.googlegroups.com> 





Here is what I think:


One way is:


1) Create another user (for this username)
give only select previlages to the objects of original schema to this
new created user.


ask the person to use the newly created user..so he can only view
through the select previlage.


Rename the password of the original schema..



Just my opinion..


Nirav
Received on Thu Jun 09 2005 - 08:35:05 CDT












Original text of this message













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