OraFAQ Forum: Forms » Restricting some users from connecting with database using tools other than forms Runtime, Repor

Home » Developer & Programmer » Forms » Restricting some users from connecting with database using tools other than forms Runtime, Repor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restricting some users from connecting with database using tools other than forms Runtime, Repor [message #302823]

Wed, 27 February 2008 02:05

nasir_mughal
Messages: 122
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

Report message to a moderator

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

sasipalarivattom
Messages: 121
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

nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi

Senior Member

Thank u Sir.

Report message to a moderator

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

dillango
Messages: 145
Registered: January 2008

Senior Member

Mr.Sasi,

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

Ilango

Report message to a moderator

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

sasipalarivattom
Messages: 121
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..

Report message to a moderator

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

nasir_mughal
Messages: 122
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

Report message to a moderator

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

nasir_mughal
Messages: 122
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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 20:13:09 CDT 2025