Home » RDBMS Server » Server Administration » disabling access to users
disabling access to users [message #57330] Fri, 06 June 2003 00:20 Go to next message
rameshkumar
Messages: 12
Registered: May 2003
Junior Member
hi all,
how to disable the users access to the database using sql*plus, TOAD. I want the users to connect only thru the application

all the replies r most welcome

Report message to a moderator

Re: disabling access to users [message #57331 is a reply to message #57330] Fri, 06 June 2003 02:10 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Tom Kyte knows...

MHE

Report message to a moderator

Re: disabling access to users [message #57343 is a reply to message #57330] Fri, 06 June 2003 16:57 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Nothing easier than that. You can create LOGON trigger to check which program user used to login. If SQL*PLus - terminate the session. Well explained Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Urgent! Oracle 8.1.7 restore on Windows 2000
Next Topic: Difference between Oracle 8i and 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:31:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.