I don't use a auto script as security is an auditable spec for me. I usually rename and disable the accounts for a start.

Then over time progress through...

Thanks Again Lynn

I was going to create one trigger for both inserts and updates, but I think I need to seperate them out due to different audit needs. ...

Thanks Lynn

I had considered it was possible, but now I know I can do this . Progamming has never been a strength or passion of mine so I usually...

Okay here's the code

create TRIGGER [dbo].[TRG_AUDIT_UPDATE_SITES]

ON [dbo].[REGISTERED_SITES]

AFTER INSERT, UPDATE

AS

BEGIN

declare @NULLvarchar100varchar(100),

@NULLvarchar60varchar(60),

@NULLintint,

@NULLbitbit,

@NULLchar1char(1),

@NULLchar2char(2),

@NULldatetimedatetime,

@NULLnchar10nchar(10)

set@NULLvarchar100 = NULL;

set@NULLvarchar60 = NULL;

set@NULLint = NULL;

set@NULLbit = NULL;

set@NULLchar1 =...

When I backfill for another DBA at my outsourcing company, I telecommute to do support times as requested by the client.

It's okay, but very slow so I only use...

My reason to work part time is my young child. I'd not work at all and be a fulltime mum if I could, but like everyone I have...

Abba

I work as a 20 hour per week DBA. I've been in DBA and Unix Admin work for the last 15 years as a normal fulltime plus on-call...

As other DBAs have mentioned earlier in this post orafaq is a good one, Oracle itself has metalink with the new dashboard functionality (which is rather nice in a gui...

escape outer view

cascade is like cross current

primary break between

public statistics

trigger off foreign values

convert user view

The rule of thumb I follow seems to be the hourly rate you where getting ie $75 should have three zeros added to the end for an...

I've been asked by the management in my current IT company to gain this qualification even though I've personally don't see what benefits it provides me as a parttime dba...

I'm an Ess Cue Elle type of DBA. This is due to my Oracle DBA background prior to adding to my skill set as a SQLServer DBA. ...

Thanks for the replies. I will confirm tomorrow if we have a solution.

Just to clarify only I have SA password in production, so unsure why you'd think...

The error message we get is:

Database diagram support objects cannot be installed because this database does not have a valid owner. Ton continue, first user the files page of...