How do you prevent users from logging in

Post Reply
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

How do you prevent users from logging in

Post by telula »

Hello,
Is there a way to prevent users from accessing the cubes ?
I am in the middle of making changes to the TI processes and re-loading etc. I want to stop users from logging in. How can I do that?
Alan Kirk
Site Admin
Posts: 6645
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: How do you prevent users from logging in

Post by Alan Kirk »

telula wrote:Hello,
Is there a way to prevent users from accessing the cubes ?
I am in the middle of making changes to the TI processes and re-loading etc. I want to stop users from logging in. How can I do that?
Quick and dirty approach:
- Do a data save.
- Take a copy of the }ClientProperties.cub file in case anything goes wrong.
- Make sure that logging is on on that cube.
- Open a browse of the cube.
- Copy your password value into everyone else's Password cell.
- When you're done, open the log file viewer, find the transactions where you changed their passwords to yours, then roll them back.
- If anything goes wrong in that process, shut down the server, copy the }ClientProperties.cub file that you took a copy of on step 2 into the data directory and restart.

Or you could just send an e-mail to them asking them not to log in while you're making the changes...
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: How do you prevent users from logging in

Post by Gregor Koch »

Hi

I really like Alan's solution but unfortunately it doesn't quite work with Integrated Login being turned on.
Just in case you are using it, you would need to delete the values the UniqueID field instead(and bring them back after you are done).

Cheers
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How do you prevent users from logging in

Post by lotsaram »

If you have no development server then Alan's suggestion is a pretty good hack to prevent users accessing the system. (If the UI is tm1 web only then you could also simply stop IIS.)

Really you should be making these changes in a test or development environment and then migrating the objects to production! If your organization hasn't shelled out for a development environment then you can still do development on your local server (the poor man's dev environment) and make sure whatever you are doing is tested and works before migrating to production. This is much more preferable to the alternative you are considering.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: How do you prevent users from logging in

Post by David Usherwood »

I did something similar recently via rules, forcing a password over most users - because of the encryption they couldn't use it. Take away the rule and the stored pwds came back.
Don't think you could interfere with integrated login without downing the server and changing type back to 1.
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: How do you prevent users from logging in

Post by Gregor Koch »

Hi David,

You are right, you cannot change the setting for IL without a restart. But without a UniqueID users cannot log on nevertheless.
Cheers
Post Reply