 | |
#1
 
| |||
| |||
|
restrict login -
01-04-2012
, 12:59 AM
#2
| |||
| |||
|
|
how to restrict unauthorized user by using logon trigger???? means in my data dictionary i hv number ip to whom i want to give access n other i dnt want so how can i perform that by logon trigger ???????? |
--
http://mgogala.byethost5.com
#3
| |||
| |||
|
|
how to restrict unauthorized user by using logon trigger???? means in my data dictionary i hv number ip to whom i want to give access n other i dnt want so how can i perform that by logon trigger ???????? |
The sqlnet layer of Oracle has parameters that can be used to allow
and block access to the listener based on IP addresses. This feature
might be of interest to you.
You also failed to list your full version and edition of Oracle. Your
options related to database event logon triggers vary somewhat on the
version and if you have the Standard Edition or Enterprise Edition.
With a modern version of the EE you could check the IP address of a
session in a logon trigger and set a context value that is used by
FGAC (VPD) to filter query results providing what you actually want to
do is something that the VPD feature applies to. Like I said earlier
your intent is not clearly stated.
HTH -- Mark D Powell --
#4
| |||
| |||
|
|
how to restrict unauthorized user by using logon trigger???? means in my data dictionary i hv number ip to whom i want to give access n other i dnt want so how can i perform that by logon trigger ???????? |
exactly?
#5
| |||
| |||
|
|
On Jan 4, 1:59*am, DHILEN JOGI <kanoj... (AT) gmail (DOT) com> wrote: how to restrict unauthorized user by using logon trigger???? means in my data dictionary i hv number ip to whom i want to give access n other i dnt want so how can i perform that by logon trigger ???????? Dihilen, your post is not very clear, access to what? The sqlnet layer of Oracle has parameters that can be used to allow and block access to the listener based on IP addresses. *This feature might be of interest to you. You also failed to list your full version and edition of Oracle. *Your options related to database event logon triggers vary somewhat on the version and if you have the Standard Edition or Enterprise Edition. With a modern version of the EE you could check the IP address of a session in a logon trigger and set a context value that is used by FGAC (VPD) to filter query results providing what you actually want to do is something that the VPD feature applies to. *Like I said earlier your intent is not clearly stated. HTH -- Mark D Powell -- |
my oracle verson is oracle 10g standard edition
and u correctly got my prob that i wants to restrict people
whose ip does not exist in my database table...
n i want to perform that by using trigger which fired on logon
in my database so hoe i can perform
and
my oracle verson is oracle 10g standard edition
also
my internet is working properly......
thnx in advance...
#6
| |||
| |||
|
|
On Jan 4, 1:59*am, DHILEN JOGI <kanoj... (AT) gmail (DOT) com> wrote: how to restrict unauthorized user by using logon trigger???? means in my data dictionary i hv number ip to whom i want to give access n other i dnt want so how can i perform that by logon trigger ???????? Dihilen, your post is not very clear, access to what? The sqlnet layer of Oracle has parameters that can be used to allow and block access to the listener based on IP addresses. *This feature might be of interest to you. You also failed to list your full version and edition of Oracle. *Your options related to database event logon triggers vary somewhat on the version and if you have the Standard Edition or Enterprise Edition. With a modern version of the EE you could check the IP address of a session in a logon trigger and set a context value that is used by FGAC (VPD) to filter query results providing what you actually want to do is something that the VPD feature applies to. *Like I said earlier your intent is not clearly stated. HTH -- Mark D Powell -- |
my oracle verson is oracle 10g standard edition
and u correctly got my prob that i wants to restrict people
whose ip does not exist in my database table...
n i want to perform that by using trigger which fired on logon
in my database so hoe i can perform
and
my oracle verson is oracle 10g standard edition
also
my internet is working properly......
thnx in advance...
dhilen jogi
#7
| |||
| |||
|
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.