Create Profile (for password admin or resource limits)

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Create Profile (for password admin or resource limits)

Postby bravura » 08. November 2011 03:51

For my class we were instructed to set password limits on the users we created. Of course the book only lists the limits (ie PASSWORD_LIFE_TIME) but does not tell us how to do it. I found online the following syntax:

CREATE PROFILE app_user2 LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_TIME 60
PASSWORD_REUSE_MAX 5
PASSWORD_VERIFY_FUNCTION verify_function
PASSWORD_LOCK_TIME 1/24
PASSWORD_GRACE_TIME 10;

So I assume one needs to create the profile first, then assign it to my user. I've tried to set up the profile, but I receive ERROR 1064 (error in SQL syntax.) Is there a flaw in the syntax, am I trying this in the wrong place (xampp/mysql/bin/mysql -u root and/or 'use mysql'), or is there something I need to do in the config files?

Thanks so much for your help, I've been at this for hours (in addition to trying to figure out "exec sp_password" and creating local and domain groups but I'm sure I can figure out those once I see how my question above is resolved (i'm not trying to get out of doing my own homework - I don't get straight A's slacking off!)
bravura
 
Posts: 8
Joined: 05. November 2011 03:18
Operating System: Windows Vista 64

Re: Create Profile (for password admin or resource limits)

Postby Altrea » 08. November 2011 03:58

bravura wrote:I found online the following syntax:

CREATE PROFILE app_user2 LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_TIME 60
PASSWORD_REUSE_MAX 5
PASSWORD_VERIFY_FUNCTION verify_function
PASSWORD_LOCK_TIME 1/24
PASSWORD_GRACE_TIME 10;

I think thats for ORACLE not for MySQL, so it will not run with MySQL.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8299
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Create Profile (for password admin or resource limits)

Postby bravura » 08. November 2011 04:02

It is, i thought i could run it on MySQL...
bravura
 
Posts: 8
Joined: 05. November 2011 03:18
Operating System: Windows Vista 64

Re: Create Profile (for password admin or resource limits)

Postby bravura » 08. November 2011 04:11

ps. Teacher has us using MySQL and most of the books examples are for Oracle - get a load of that!

you can end thread. thanks.
bravura
 
Posts: 8
Joined: 05. November 2011 03:18
Operating System: Windows Vista 64


Return to XAMPP for Windows

Who is online

Users browsing this forum: JJ_Tagy and 41 guests