Discussion:
How can I get a list of firebird db users?
Ahmet Nuri D
2012-01-11 07:07:39 UTC
Permalink
Hi, I want to list firebird user. can I do that?
Thomas Steinmaurer
2012-01-11 07:12:09 UTC
Permalink
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
If you mean the instance-wide available Firebird users, then either use
the Services API or gsec.

What development environment, access components etc. do you use?
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Ahmet Nuri D
2012-01-11 07:22:11 UTC
Permalink
I am useing Lazarus and Lazarus own Ib connection components .
I am useing for Flame Robin for databese interface.
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
If you mean the instance-wide available Firebird users, then either use
the Services API or gsec.
What development environment, access components etc. do you use?
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Thomas Steinmaurer
2012-01-11 07:31:48 UTC
Permalink
Post by Ahmet Nuri D
I am useing Lazarus and Lazarus own Ib connection components .
Can't help you with Lazarus. I don't know what IB connection components
Lazarus has included. Perhaps there are components exposing the Services
API in particular for managing Firebird users. I recall that in IBX
there was something called TIBSecurityService, perhaps these components
are based on IBX. I don't know.
Post by Ahmet Nuri D
I am useing for Flame Robin for databese interface.
I'm pretty sure FlameRobin can manage users just fine.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Post by Ahmet Nuri D
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
If you mean the instance-wide available Firebird users, then either use
the Services API or gsec.
What development environment, access components etc. do you use?
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Ahmet Nuri D
2012-01-11 07:42:06 UTC
Permalink
Oo, Is there any method with using sql commands ?
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
I am useing Lazarus and Lazarus own Ib connection components .
Can't help you with Lazarus. I don't know what IB connection components
Lazarus has included. Perhaps there are components exposing the Services
API in particular for managing Firebird users. I recall that in IBX
there was something called TIBSecurityService, perhaps these components
are based on IBX. I don't know.
Post by Ahmet Nuri D
I am useing for Flame Robin for databese interface.
I'm pretty sure FlameRobin can manage users just fine.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Post by Ahmet Nuri D
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
If you mean the instance-wide available Firebird users, then either use
the Services API or gsec.
What development environment, access components etc. do you use?
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Thomas Steinmaurer
2012-01-11 07:43:51 UTC
Permalink
Post by Ahmet Nuri D
Oo, Is there any method with using sql commands ?
Not for getting a list of users. CREATE/ALTER/DROP USER ... DDL
statements have been added in Firebird 2.5 though.

Please don't top-post. Thanks. ;-)
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Post by Ahmet Nuri D
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
I am useing Lazarus and Lazarus own Ib connection components .
Can't help you with Lazarus. I don't know what IB connection components
Lazarus has included. Perhaps there are components exposing the Services
API in particular for managing Firebird users. I recall that in IBX
there was something called TIBSecurityService, perhaps these components
are based on IBX. I don't know.
Post by Ahmet Nuri D
I am useing for Flame Robin for databese interface.
I'm pretty sure FlameRobin can manage users just fine.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
Post by Ahmet Nuri D
Post by Thomas Steinmaurer
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
If you mean the instance-wide available Firebird users, then either use
the Services API or gsec.
What development environment, access components etc. do you use?
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
Milan Babuskov
2012-01-11 14:46:16 UTC
Permalink
This post might be inappropriate. Click to display it.
Ahmet Nuri D
2012-01-11 14:52:45 UTC
Permalink
I find one solition for that

SELECT RDB$USER
FROM RDB$USER_PRIVILEGES
group by
1
Post by Milan Babuskov
Post by Ahmet Nuri D
Hi, I want to list firebird user. can I do that?
Start Firebird gsec tool with "-display" switch.
$ gsec -display -database srv:/opt/firebird/security2.fdb -user sysdba
-pass masterkey
user name
----------------------------------
SYSDBA
MILANB
Regards,
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
http://www.guacosoft.com/xmlwizard
==================================
Helen Borrie
2012-01-11 19:06:42 UTC
Permalink
Post by Ahmet Nuri D
I find one solition for that
SELECT RDB$USER
FROM RDB$USER_PRIVILEGES
group by
1
If it was that easy, someone would have told you about it. ;-)

All this gives you is a list of users (that may or may not exist) which have SQL privileges assigned to them *in that database*. The security database (where user accounts live) is not linked to user databases in any way.

./heLen
Trond
2012-01-12 10:15:56 UTC
Permalink
If you use Firebird version >= 2.1 you can use something like this:

SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP,
ma.MON$REMOTE_PROCESS,
ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role,
ma.mon$state,
ma.mon$stat_id, ma.mon$server_pid,ma.mon$remote_pid
FROM MON$ATTACHMENTS MA
WHERE ma.MON$ATTACHMENT_ID <> CURRENT_CONNECTION
Post by Helen Borrie
Post by Ahmet Nuri D
I find one solition for that
SELECT RDB$USER
FROM RDB$USER_PRIVILEGES
group by
1
If it was that easy, someone would have told you about it. ;-)
All this gives you is a list of users (that may or may not exist) which
have SQL privileges assigned to them *in that database*. The security
database (where user accounts live) is not linked to user databases in
any way.
./heLen
--
Mvh
Trond Dammen


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Milan Babuskov
2012-01-16 08:57:18 UTC
Permalink
Post by Trond
SELECT ma.MON$USER, ma.MON$REMOTE_ADDRESS,ma.MON$TIMESTAMP,
ma.MON$REMOTE_PROCESS,
ma.mon$attachment_id, ma.mon$attachment_name, ma.mon$role,
ma.mon$state,
ma.mon$stat_id, ma.mon$server_pid,ma.mon$remote_pid
FROM MON$ATTACHMENTS MA
WHERE ma.MON$ATTACHMENT_ID <> CURRENT_CONNECTION
Those are only connected users. He wants to get a list of all user
accounts on the server.
--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Loading...