Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
9
Newest
 Excavator
Impact
~1k people reached

Apr
4
awarded  Excavator
Apr
4
revised efficient way to poll database?
Updated URL.
Apr
4
suggested approved edit on efficient way to poll database?
Mar
8
comment Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs
@Phil I am not sure what exact business need is for the OP but one Business need for this is to build and maintain an Archive of historical data while being able to purge data from the Primary database.
Mar
7
awarded  Editor
Mar
7
revised Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs
Improved title
Mar
7
suggested approved edit on Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs
Mar
7
comment Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs
Thanks. I was going to ask the same question as OP but luckily I found this. I think we need to change the title of the question so that the topic is easily searchable.
Feb
10
awarded  Popular Question
Mar
9
comment Restrict Oracle DB Login based on SQL Client being used
@wernfried This trigger worked pretty nicely. We did some changes to it to include checking the user PROFILE and instead of checking the program we check the MACHINE from where the conncection is coming from. Our Application always connects from the App Server Machine id even when User logs on to the app from their PC and that server machine id will not change (ever). So that solves the program name problem.
Mar
9
awarded  Scholar
Mar
9
accepted Restrict Oracle DB Login based on SQL Client being used
Feb
27
awarded  Student
Feb
27
comment Restrict Oracle DB Login based on SQL Client being used
Yes, I figured that is the only safe way but revoking access privilege will mean revoke privileges from the application too, which we don't want to do. I don't think the users are that smart to be changing their connection properties ;) but the question is will a BEFORE LOGON trigger with revoke command work?
Feb
27
comment Restrict Oracle DB Login based on SQL Client being used
But we know the Application client's name. Can we restrict it like if not <app_client> then... perhaps through a BEFORE LOGON trigger? We also know the Machine Name which will always be the Application server name if the user is using the Application, that can be used as well?
Feb
26
asked Restrict Oracle DB Login based on SQL Client being used
Sep
24
awarded  Autobiographer
Mar
10
awarded  Citizen Patrol
Oct
18
awarded  Supporter
Oct
1
comment How to modify an update in Oracle so it performs faster?
Yes they are and I am aware of that. But its not what I asked? SELECT NULL... is plain confusing and shouldn't be used (unless you are using a UNION).