New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
User Account maintanance in SQL [CORE696] #1065
Comments
Modified by: @dyemanovFix Version: 3.0 [ 10048 ] assignee: Dmitry Yemanov [ dimitr ] SF_ID: 807879 => |
Modified by: @pcisarassignee: Dmitry Yemanov [ dimitr ] => |
Modified by: @dyemanovassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff Added SQL operators: CREATE USER name PASSWORD 'pass' [FIRSTNAME 'text'] [MIDDLENAME 'text'] [LASTNAME 'text']; ALTER USER name [SET] [PASSWORD 'pass'] [FIRSTNAME 'text'] [MIDDLENAME 'text'] [LASTNAME 'text']; -- at least one of PASSWORD / FIRSTNAME / MIDDLENAME / LASTNAME is required DROP USER name; Non-privileged (non-SYSDBA) user can use only: ALTER USER my_name .... |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Alpha 1 [ 10224 ] Fix Version: 3.0.0 [ 10048 ] => |
Modified by: @pcisarWorkflow: jira [ 10720 ] => Firebird [ 15040 ] |
Commented by: Vsevolod Migdisov (vmigdisov_gmail.com) Is it possible to use it in PSQL with parameters? e.g. declare variable USER_NAME char(32); for select USER_NAME, PASSWD from MY_USERS Thank you! |
Commented by: @AlexPeshkoff No. It was not planned to be used in PSQL, even without parameters (exactly like the rest of DDL). |
Commented by: Vsevolod Migdisov (vmigdisov_gmail.com) Thank you very much? |
Commented by: Vsevolod Migdisov (vmigdisov_gmail.com) CREATE USER newuser PASSWORD 'masterkey'; ERROR (2.5 Alpha, SYSDBA, IBExpert): |
Commented by: Pabloj (pabloj_sourceforge) More details on the case just reported by Vsevolod Migdisov, I'm trying to create an user and get an error, see the log: C:\Program Files\Firebird\Firebird_2_5\bin>isql -u sysdba -p masterkey localhost C:\Program Files\Firebird\Firebird_2_5\bin>isql -z SQL> select rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database; RDB$GET_CONTEXT2.5.0 Hope I gave enough details |
Commented by: Vsevolod Migdisov (vmigdisov_gmail.com) Is it possible to add statement "CREATE OR ALTER USER"? because you never know if the user exists. |
Commented by: @AlexPeshkoff CREATE OR ALTER USER? Certainly, possible - but not in 2.5 I think. |
Commented by: Vsevolod Migdisov (vmigdisov_gmail.com) and "DELETE USER" also returns an error if the USER doesn't exist, but you also never know this. |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @pcisar
Is related to QA291
Votes: 5
SFID: 807879#
Submitted By: pcisar
I think it a good idea to have the ability in the sql
interface to Create, Edit and Delete User Accounts.
E.G.
Create User "MyUsername" "MyPassword";
Delete User "MyUsername";
Alter User "MyUsername" "MyPassword" "NewPassword";
The text was updated successfully, but these errors were encountered: