Re: user maintenance

2018-10-06 Thread Harris, Steven
Not the scripts, the schedules need to be updated.

select schedule_name from admin_schedules where chg_admin='USER_X' and 
active='YES'

To fix just update the schedule by setting active yes again

Select 'upd sched '||schedule_name||' t=a active=yes' from admin_schedules 
where chg_admin='USER_X' and active='YES'

Save the output, edit as necessary and then run it.

Cheers

Steve

Steven Harris
TSM Admin/Consultant
Canberra Australia

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Efim
Sent: Saturday, 6 October 2018 4:53 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] user maintenance

Hi,
There will be problems with the scripts because they run with the rights of the 
administrator who created them.
All affected scripts must be updated by the existing administrator. (ex. add 
description or comment line).
Efim

> 5 окт. 2018 г., в 18:49, Solomon Miler  написал(а):
> 
> User_X created various entities on tsm (schedules, associations, scripts  etc 
> ).
> 
> User_X  leaves the company,
> 
> User_X  needs to be removed  from tsm.   (remove admin User_X)
> 
> Is there a concern / any side-effects you can think of.
> 
> Thank you.
> 
> 
> Solomon Miler
> Senior Data Protection Engineer, VP
> --
> Desk: 201.577.313
> Cell  :  917.287.2332
> smi...@jri-america.com
> 
> 
> ***
> 
> This email and any files transmitted with it are confidential and 
> intended solely for the use of the individual or entity to whom they 
> are addressed. If you have received this email in error please notify 
> the sender by replying to this email and then delete it from your 
> system.
> 
> No reliance may be placed upon this email without written confirmation 
> of its contents and any liability arising from such reliance without 
> written confirmation is hereby excluded.
> 
> JRI America
> 
> ***
> 

This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure. You should immediately delete the message 
if you are not the intended recipient. If you have received this email by 
mistake please delete it from your system; you should not copy the message or 
disclose its content to anyone. 

This electronic communication may contain general financial product advice but 
should not be relied upon or construed as a recommendation of any financial 
product. The information has been prepared without taking into account your 
objectives, financial situation or needs. You should consider the Product 
Disclosure Statement relating to the financial product and consult your 
financial adviser before making a decision about whether to acquire, hold or 
dispose of a financial product. 

For further details on the financial product please go to http://www.bt.com.au 

Past performance is not a reliable indicator of future performance.


Re: user maintenance

2018-10-05 Thread Efim
Hi,
There will be problems with the scripts because they run with the rights of the 
administrator who created them.
All affected scripts must be updated by the existing administrator. (ex. add 
description or comment line).
Efim

> 5 окт. 2018 г., в 18:49, Solomon Miler  написал(а):
> 
> User_X created various entities on tsm (schedules, associations, scripts  etc 
> ).
> 
> User_X  leaves the company,
> 
> User_X  needs to be removed  from tsm.   (remove admin User_X)
> 
> Is there a concern / any side-effects you can think of.
> 
> Thank you.
> 
> 
> Solomon Miler
> Senior Data Protection Engineer, VP
> --
> Desk: 201.577.313
> Cell  :  917.287.2332
> smi...@jri-america.com
> 
> 
> ***
> 
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity 
> to whom they are addressed. If you have received this 
> email in error please notify the sender by replying to this 
> email and then delete it from your system.
> 
> No reliance may be placed upon this email without written
> confirmation of its contents and any liability arising from 
> such reliance without written confirmation is hereby 
> excluded.
> 
> JRI America
> 
> ***
> 


Re: user maintenance

2018-10-05 Thread Rick Adamson
Solomon
While it is never an acceptable best practice, users do sometimes use an 
individual account to automate tasks. It's possible that external tasks, jobs, 
scripts, etc. have been configured to use that account to authenticate with the 
server(s). However, anything created like schedules and associations would be 
unaffected.

Assuming you have at least one other account the has "System" privilege, I 
would just lock the User_X account and let the system cook for a few days to 
see if there is any negative impact.

If any issues arise you can address them accordingly and once there are no 
problems remove the account

To verify you have another account with system access: query admin
To lock account: lock admin user_x
To unlock the account: unlock admin user_x
To remove the account: remove admin user_x

Depending on you configuration you may need to repeat on all TSM servers.

-Rick Adamson


-Original Message-
From: ADSM: Dist Stor Manager  On Behalf Of Solomon Miler
Sent: Friday, October 5, 2018 11:50 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] user maintenance

* This email originated outside of the organization. Use caution when opening 
attachments or clicking links. *

--
User_X created various entities on tsm (schedules, associations, scripts  etc ).

User_X  leaves the company,

User_X  needs to be removed  from tsm.   (remove admin User_X)

Is there a concern / any side-effects you can think of.

Thank you.


Solomon Miler
Senior Data Protection Engineer, VP
--
Desk: 201.577.313
Cell  :  917.287.2332
smi...@jri-america.com


***

This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the sender by replying to 
this email and then delete it from your system.

No reliance may be placed upon this email without written confirmation of its 
contents and any liability arising from such reliance without written 
confirmation is hereby excluded.

JRI America

***


**CONFIDENTIALITY NOTICE** This electronic message contains information from 
Southeastern Grocers, Inc and is intended only for the use of the addressee. 
This message may contain information that is privileged, confidential and/or 
exempt from disclosure under applicable Law. This message may not be read, 
used, distributed, forwarded, reproduced or stored by any other than the 
intended recipient. If you are not the intended recipient, please delete and 
notify the sender.