Home » Developer & Programmer » Forms » Restricting some users from connecting with database using tools other than forms Runtime, Repor
Restricting some users from connecting with database using tools other than forms Runtime, Repor [message #302823] Wed, 27 February 2008 02:05 Go to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member

I want to restrict some users from connecting with database using tools like Forms Builder, Reports Builder, Sqlplus and allow them to connect using tools Oracle Forms Runtime, Oracle Reports Runtime , Graphics Runtime.

Anybody help me how can i achieve this.


Thanx



Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #302833 is a reply to message #302823] Wed, 27 February 2008 02:19 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Dear Nazir,

Please check this script..
script
It is from orafaq itself. So before you post something,
Please do search it in orafaq.
It will save your time..

Regards,
Sasi Palarivattom.

[Updated on: Wed, 27 February 2008 02:19]

Report message to a moderator

Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #302849 is a reply to message #302823] Wed, 27 February 2008 03:01 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Thank u Sir.
Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #302856 is a reply to message #302833] Wed, 27 February 2008 03:23 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Mr.Sasi,

This code will it applicable for connecting through Forms and Reports design environment?

Ilango

Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #302865 is a reply to message #302856] Wed, 27 February 2008 03:43 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Dear Dilango,

Yes It will work.
Program name for Forms developer is ifbld90.exe.
and that for Report Builder is rwbuilder.exe
and for forms runtime, it is ifweb90.exe
You can restrict these programs also.

Say thanks to Frank Naude For such a script.

Regards
Sasi..
Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #302889 is a reply to message #302823] Wed, 27 February 2008 04:42 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Dear Mr. Sasi

If i connect using 'Form builder' or 'report builder' or 'forms runtime' oracle does't return program name on quering 'v$session' instead of program name it is returning NULL.

so how can i block these tools
please help me.


Regards.
Nasir
Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #303932 is a reply to message #302889] Mon, 03 March 2008 05:54 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Hi Everyone

Is there any procedure to restrict users from connecting through 'Form builder' or 'report builder' or 'forms runtime'.

oracle returns NULL in program name colum on quering 'v$session' instead of program name when i connect through 'Form builder' or 'report builder' or 'forms runtime'.

so how can i block these tools

please help me.

Regards.
Nasir
Re: Restricting some users from connecting with database using tools other than forms Runtime, R [message #304056 is a reply to message #303932] Mon, 03 March 2008 22:26 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you don't want developers to connect to a production database tell them that if you find them doing it, you will fire them.

It works here.

David
Previous Topic: Shifting Microsoft Access Forms and Reports to Oracle 9i
Next Topic: ORA-06508 in Form using library
Goto Forum:
  


Current Time: Sun Dec 04 23:04:13 CST 2016

Total time taken to generate the page: 0.06376 seconds