Tag Info

New answers tagged

0

What you desire is called Proxy Authentication. Not sure how well MySQL handles it, but MariaDB does and so does PostgreSQL. Do you need to use Connection Pooling? How many concurrent users do you expect? Here's how it would work in PostgreSQL: create role neil login password 'secret'; create role www noinherit login password 's3cret'; grant neil to ...


0

Improvement: Added login user, IP Address. It will show who has given grant or revoke. Log Table create table log ( Action_DaTe date , Pvs_name varchar2(15) , PRIVILEGE varchar2(30) , OWNER varchar(20) , OBJECT_NAME varchar2(30) , Username varchar2(30) , login_user varchar2(20) , IP_address varchar2(15) ); Modified ...


1

I really like your idea of inserting XML before and after images of the changed data. IMHO, it is not light weight enough for a trigger. I've changed the whole WHILE loop to the following (sorry for the different names) insert into audit (table_name, old_content, new_content) select @table_name, case when d.table_id is null then null else (select ...



Top 50 recent answers are included