;)
;)
;)
I've done the infamously dumb and newbish... I've locked myself out (I am the administrator). I was fiddling around with everything, so happy that it all was working so well...And I changed my User Role to Operations Manager from Administrator. Right afterwards, *bam* no more Admin access... Can anyone give me a simple way to get back in? I have full access to my server (Running Debian Linux with Postgresl 7.4.5-3), but I know very little about database administration. A step-by-step would be SO cool, but if not anything will do. Thank you!!!
Discuss Administration
Administrator lockout...D'oh!
You need to be logged in to post messages
1.
10/29/2004
8:46 AM
EDT
You should be able to change your role from Postgres... maybe just logging out/logging in will work after the change, or you might have to restart Tomcat because there is data being cached in the application.
From the command line:
$ psql <databasename>
if you can't remember the database name, try:
$ psql -l
for a listing.
If PostgreSQL says you connected properly, then you can issue:
=# update access set role_id = 1 where username = 'some.user';
If you need to see a list of users, you can try:
=# select username from access;
2.
10/29/2004
7:26 PM
EDT
Thank you SO much! I realized that since it was midnight PST when I posted that question, I wouldn't get any reply for a few hours at least.. so I just re-installed.
P.S. I wanted to say thanks anyway to the CentricCRM team, and I am absolutely floored by CentricCRM. This software is among the most user-friendly, intuitive, complete packages I have ever seen! Please keep up the good work, and expect my payment for an executive version once my business gets off the ground!! I know that this software will help me do exactly that! I am so excited.
3.
11/8/2004
5:09 PM
EST
I am using the hosted version and also seem to have locked myself out by just changing my username and cant login with the new username and old password also isnt there a way to set-up your own password so its easier to remember?
Thanks
4.
11/9/2004
8:44 AM
EST
Each user can change their password by going to the "My Home Page" module, choosing "Settings" and then "Change my password"
5.
4/8/2008
8:39 AM
EDT
By Mpere Kobe
I forgot my password (administrator) and requested the application to generate a new one - which it does but I get this error:
Access: ORA-00904: "PASSWORD": invalid identifier
Any ideas as to what it is and how to solve it?
MK
6.
4/8/2008
1:19 PM
EDT
Mpere Kobe wrote:
I forgot my password (administrator) and requested the application to generate a new one - which it does but I get this error:
Access: ORA-00904: "PASSWORD": invalid identifier
Any ideas as to what it is and how to solve it?
MK
What version of ConcourseSuite are you using, and what version of Oracle? This appears to be a bug that's isolated to the oracle database scripts.
6 results found