Skip to content
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

ALTER USER XXX INACTIVE [CORE2004] #2441

Closed
firebird-automations opened this issue Jul 18, 2008 · 7 comments
Closed

ALTER USER XXX INACTIVE [CORE2004] #2441

firebird-automations opened this issue Jul 18, 2008 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Mercea Paul (m24paul)

Votes: 3

I would like to have the possibility to inactivate the user!This could preserve all right but not allow her/him to log in!
For version 3 could be inactivated just for database1 or 2...etc, and active for database 6 or 9 !

Commits: 64b4f89 FirebirdSQL/fbt-repository@84c5aa8

====== Test Details ======

Sent letters to dimitr and alex:
1) 09.03.2018 19:33.
2) 10.03.2018 16:00 (about need of granting rdb$admin role)

See also test for CORE5770

Test was committed because it does some checks of ability to make user active/inactive.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

With version 2.1 it is easy with ON CONNECT TRIGGER and database per database
SQL> SET TERM ^ ;
SQL> CREATE EXCEPTION EX_CONNECT 'Forbidden !' ^
SQL> CREATE OR ALTER TRIGGER TRG_CONN ON CONNECT
CON> AS
CON> BEGIN
CON> IF (USER != 'GOOD_USER')
CON> THEN EXCEPTION EX_CONNECT USER || ' not allowed !';
CON> END ^
SQL> EXIT ^

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Deferred

Test Details: Sent letter to dimitr, alex, 09.03.2018 19:33. Waiting for reply.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Deferred => Done with caveats

Test Details: Sent letter to dimitr, alex, 09.03.2018 19:33. Waiting for reply. => Sent letters to dimitr and alex:
1) 09.03.2018 19:33.
2) 10.03.2018 16:00 (about need of granting rdb$admin role)
Waiting for reply.

Test was committed because it does some checks of ability to make user active/inactive.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done with caveats => Done successfully

Test Details: Sent letters to dimitr and alex:
1) 09.03.2018 19:33.
2) 10.03.2018 16:00 (about need of granting rdb$admin role)
Waiting for reply.

Test was committed because it does some checks of ability to make user active/inactive.

=>

Sent letters to dimitr and alex:
1) 09.03.2018 19:33.
2) 10.03.2018 16:00 (about need of granting rdb$admin role)

See also test for CORE5770

Test was committed because it does some checks of ability to make user active/inactive.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants