Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: need final word on sysdba

Re: need final word on sysdba

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Feb 2006 11:19:28 -0800
Message-ID: <1138907968.824552.60900@f14g2000cwb.googlegroups.com>


Randy, you need to setup a password file to be able to connect as sysdba remotely. Otherwise only local sysdba connects are allowed.

I suggest that you do not give the vendor the sys or system ID's. Rather grant DBA to an ID created for the vendor. The vendor should not need access to the actual Oracle account and likely just needs a slew of database object DDL privileges, that is, system privileges like CREATE TABLE, CREATE VIEW, Unlimited Quota, etc.... Some vendors even know what privilege their application needs are you can just grant these rather than sysdba or even DBA.

HTH -- Mark D Powell -- Received on Thu Feb 02 2006 - 13:19:28 CST

Original text of this message

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