Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.germany.com!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail From: "fireball" Newsgroups: comp.databases.oracle.server Subject: Re: user with administrative priviledges Date: Tue, 10 Oct 2006 08:54:55 +0200 Organization: tp.internet - http://www.tpi.pl/ Lines: 29 Message-ID: References: <1160423712.481534.145160@h48g2000cwc.googlegroups.com> NNTP-Posting-Host: 195.116.44.3 X-Trace: atlantis.news.tpi.pl 1160463566 6708 195.116.44.3 (10 Oct 2006 06:59:26 GMT) X-Complaints-To: usenet@tpi.pl NNTP-Posting-Date: Tue, 10 Oct 2006 06:59:26 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276889 Uzytkownik "Anthony" napisal w wiadomosci > > 100% agree with you. You are inviting potential troubles down the road. > argue please I've walked through some oracle's guides (ex. http://www.utexas.edu/its/unix/reference/oracledocs/v92/B10501_01/server.920/a96521/dba.htm#834), and oracle newsgropus archives as well, - and Iv'e learned lesson not to use SYS/SYSTEM to perform just db administration tasks, so I got little bit confused now. Please give more light to the subject Uzytkownik "Frank van Bortel" napisal w wiadomosci > all other work should be done by a normal user would you please mention exact role/grants that means 'normal' user? ps: what is a difference between: conn user/pwd as sysdba and conn user/pwd as normal assuming, user has DBA role granted. ?