
	Home > Ask the Oracle Experts > Questions & Answers

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Accessing authorized, single Oracle user

EXPERT RESPONSE FROM: Azim Fahmi

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

QUESTION POSED ON: 22 March 2004
Is it possible that a single Oracle user should be bound by a given TNS?
Just like: sqlplus scott/tiger@ONLYSCOTTALLOWED...
... no other users used this ONLYSCOTTALLOWED db connection.
If it is possible, then please give me a solution or alternate method to resolve this problem.

I am developing Web applications and want to access the only authorized Oracle single user.

EXPERT RESPONSE
The best method would be to ensure you control access to DB objects through grants to the objects that will be accessible through your web-application. You can have a role that has necessary select, delete, update, execute, etc. privileges on the objects owned by the schema and assign the role to the web user.

Please note certain default users get created in addition to SYS and SYSTEM and on many instances those users default passwords are never changed. (i.e. CTXSYS). Please ensure that the DBA users' passwords are not default passwords; in addition you may want to alter the passwords of default user like CTXSYS. And if you are absolutely adamant about a single schema user (if you web application connect to the database using this connect string through DB Properties file), revoke the create session privilege of other users that you will not need. However, please make sure you do not do so for SYS or SYSTEM J. I do not know whether you can though.

Digg This!

StumbleUpon

Del.icio.us

RELATED RESOURCES

	2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
	Search Bitpipe.com for the latest white papers and business webcasts
	Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy