Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!feed.cgocable.net!news.stealth.net!news.stealth.net!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr14.news.prodigy.com.POSTED!34d3422d!not-for-mail From: Karsten Farrell User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: user creation References: <17f23855.0210302324.7b62e3ed@posting.google.com> <3DC1607F.941F17F8@exesolutions.com> <17f23855.0211102301.318cb793@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 43 Message-ID: NNTP-Posting-Host: 67.117.210.172 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr14.news.prodigy.com 1037047780 ST000 67.117.210.172 (Mon, 11 Nov 2002 15:49:40 EST) NNTP-Posting-Date: Mon, 11 Nov 2002 15:49:40 EST Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: FKPO@MC@@S@KBUT^AZNX_T\BUSXB@DTMNHWB_EYLJZ]BGIELK^RAQFW[ML\THRCKV^GGZKJMGV^^_JSCFFUA_QXFGVSCYRPILH]TRVKC^LSN@DX_HCAFX__@J\DAJBVMY\ZWZCZLPA^MVH_P@\\EOMW\YSXHG__IJQY_@M[A[[AXQ_XDSTAR]\PG]NVAQUVM Date: Mon, 11 Nov 2002 20:49:40 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.server:166577 X-Received-Date: Mon, 11 Nov 2002 13:49:48 MST (news.easynews.com) ANJAL wrote: > Daniel Morgan wrote in message news:<3DC1607F.941F17F8@exesolutions.com>... > >>Billy Verreynne wrote: >> >> >>>ANJAL wrote: >>> >>> >>>> can anyone tell me how to creat user similar to oracle user in unix >>> >>>In Oracle or in Unix? >>> >>>-- >>>Billy >> >>And what do you mean by similar? >> >>Daniel Morgan > > > in unix, similar means have same profile like oracle but restricted > previleged, so that user can't login with oracle username in sql plus. Different flavors of Unix have different methods (tools) for adding an o/s user. Look in the sysadmin manual for your o/s (or post a question on your o/s specific NG). If you don't want to use a tool, you can do it the old-fashioned way: 1. Edit /etc/passwd and copy the line that starts with 'oracle' to a new line and make any changes necessary. 2. Edit /etc/group to add the new user's id to the list of oinstall. 3. Create a directory for your new user (same as the one specified in step 1 above). Copy any startup files to this directory (depends on which shell you assign to your new user - such as .profile). 4. Anything else required. To prevent the user from connecting with sqlplus, set their Product User Profile (look up in Oracle docs at http://tahiti.oracle.com).