Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locked out of SuperVisor (Login Disabled HELP) 1

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Some of you may have experienced this in the past, I have fallen victim of the classic 3 failed login attempts disables the SUPERVISOR login.

Does anyone know how to resolve this issue, currently I cannot think of anyway to reset the login for supervisor.

Signed
Locked-Out (brian)
 
Hello Brian,

There is no easy way out of such a mess. Contact Business Objects so they can reset the account. Alternative would be to start all over again from scratch.

A bit of advice (for you regrettably too late), never ever use Business Objects without having first created at least 2 supervisor accounts. My second account/password is stored in our safe, in case I have a black-out.
 
don't rush into starting from scratch !
By resetting some values in tables you enable the account easily. pls contact your BO support people as also suggested by 'blom0344'. They will give the needed info.
 
You dont need to contact BusinessObjects Support.

You can run an update query on the OBJ_M_ACTOR table in the repoistory to be able to reset the account password and remove the block and reset the password. I'm not in the office today so doing this from memory so the table column names me not be exactly accurate.

Update OBJ_M_ACTOR
Set OBJ_M_PASSWORD='',
Set OBJ_M_STATUS=1
where OBJ_M_ACTORNAME='NAME OF SUPERVISOR LOGIN'

The will reset the password to blank and the obj_m_status will set itself to a "new" user.

If this doesnt work let me know at Paul.Cairns@WarnerBros.com and I'll give you the exact column names and values they should be set to.

Hope this helps
Regards
Paul

 
Paul,
since u seem knowledgable about repository tables could u please help me with a problem I have.
I am trying to retrive users, their groups and their accessible universes from a default uni mapped to the repo tables.For users and groups it seems fine but when I add status its analysing forever without fetching the results.I thought that the repo uni design done by BO people is perfect.Please help.
Is there any other way to retrieve this same data.
 
Hello Somalia,

A universe on the repository tables can , I imagine cause a bit of self-referencing. Did you give any idea to linking the required tables in Access and then trying to run a query? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
 
Hi Somalia,

I have a universe that I built to do exactly this. You need to do a decode on the sttus to make it into something meaningful...

Drop me a note at Paul.Cairns@WarnerBros.com and I'll send it on to you.

Cheers
Paul Paul.Cairns@Warnerbros.com
 
Another option is the print command in Supervisor. If you print to a table, then you can build a report from the resulting text file.

You should experiment with it and see if it does what you looking for.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top