Logon trigger as below:
create or replace TRIGGER USER3.MY_TRIGGER
IF SYS_CONTEXT ('USERENV', 'SESSION_USER') IN ('USER30') THEN
IF SYS_CONTEXT ('USERENV', 'HOST') NOT IN ...
I have 100+ databases in my instace of SQL SERVER and mostly is a legacy DB but i dont have a control of what is new and what is old.
My idea is create a Trigger in all server for every transact and ...
I want to create a logon trigger. Trigger will do the following:
It will block access to the database based on certain users and
certain machine information. Then it will give an information message
Some of developers on my team know passwords from SQL accounts that have extended permissions
We would like to track and be alerted whenever any of developers are using any of those SQL accounts to ...
I've to implement the following requirement:
Access to SQL Server instance shall be allowed only from a C# application.
Users shall not be able to access any database (even those in which they have ...