Re: [firebird-support] Replication SW experience

[Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]]

Hi Helen,
sorry for question too specific to ibReplicator.

I still looking for replication SW, because all SW mentioned here 
(ibReplicator,  symmetricds, CopyCat) has some issues.
Or experience with writing it by self from someone who already did it.

Thank you for understanding.

Slavek

Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 28.11.2015 19:05, Helen Borrie hele...@iinet.net.au 
[firebird-support] wrote:
> Sunday, November 29, 2015, 2:08:01 AM, Slavomir Skopalik 
> skopa...@elektlabs.cz wrote:
>
>> Thank you,
>> I was try (IBP Replicator) and I found few problems.
> This list is for Firebird.  Questions about third-party applications
> are off-topic here.
>
> For help with IBP Replicator, please subscribe to the mailing list for
> that application:
>
> List-Subscribe: ,
>   
>
>
> Helen (Moderator)
>
>








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

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

++


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-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

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

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Hi Alan, 

 I have the latest personal edition of ibExpert.
 And quite unfortunately. 
 It does not have a second tab.
 

 Kind Regards,
 

 Robert.

Re: [firebird-support] How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Hi Thomas, 

 I can see that, but how does that help me find the overall percentage of the 
database size. Unless I know the total amount of pages being used by the 
database. I have been googling to find out this information without much luck.
 

 Kind Regards,
 

 Robert.

Re: [firebird-support] How much percentage of a database space is a table contents taking.

[Helen Borrie hele...@iinet.net.au [firebird-support]]

[firebird-support] RDB$ADMIN ROLE in security databese

[Neagu nea...@gmail.com [firebird-support]]

Hi


Firebird 2.5 introduces the RDB$ADMIN ROLE.  In the security database, 
it means, the ability to create, drop and alter user accounts. For this 
we can use SQL command CREATE or ALTER USER with parameter GRANT/REVOKE 
ADMIN ROLE to manage users RDB$ADMIN ROLE in the security database.
When I connect to a database with  SYSDBA, I can obtain a list of users, 
using an SQL SELECT from RDB$USER_PRIVILEGES, but how can i know if a 
user have or not the ADMIN ROLE in the security database ?


Neagoe Basarab


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Re: [firebird-support] RDB$ADMIN ROLE in security databese

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Hello Neagu,

Monday, November 30, 2015, 3:58:51 PM, you wrote:

> Hi


> Firebird 2.5 introduces the RDB$ADMIN ROLE.  In the security database,
> it means, the ability to create, drop and alter user accounts. For this
> we can use SQL command CREATE or ALTER USER with parameter GRANT/REVOKE
> ADMIN ROLE to manage users RDB$ADMIN ROLE in the security database.
> When I connect to a database with  SYSDBA, I can obtain a list of users,
> using an SQL SELECT from RDB$USER_PRIVILEGES, but how can i know if a 
> user have or not the ADMIN ROLE in the security database ?

When you use CREATE / ALTER USER, even though you are logged into a
regular database, you are actually working in the security database,
to which you otherwise do not have SQL access.

When you query RDB$USER_PRIVILEGES, you are looking at the privileges
that are stored in the current database (CURRENT_CONNECTION). You
cannot see privileges that apply to other databases, including
security2.fdb.

You can find out which users have been granted RDB$ADMIN in the
security database, using the gsec tool. Here we are in Windows but the
output looks the same in Linux or MacOSX.

In isql, logged in as SYSDBA:
...
SQL> create user helen password 'rapunzel' GRANT ADMIN ROLE;
SQL> commit;
...
C:\Programs64\Firebird_2_5\bin>gsec -user sysdba -password U65rtwer
GSEC> display
 user nameuid   gid admin full name


SYSDBA  0 0   Sql Server Administrator
JOEBLO  0 0   Joe Bloggs
HELEN   0 0 admin
GSEC>

Helen

[firebird-support] Re: How much percentage of a database space is a table contents taking.

[rgilland1...@gmail.com [firebird-support]]

Thanks Helen, 

 I finally taught myself how to use isql.exe in order to access this 
information.
 What a strange tool.
 

 Then I found that both IBOConsole.exe and Upscene's Database Workbench show 
this information in Database Properties. And it is called "Allocated DB Pages"
 

 Kind Regards,
 

 Robert.

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

rgilland1...@gmail.com [firebird-support] schrieb am 30.11.2015 05:10:

> Thanks Helen, 
> 
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
> 
> 
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this information in Database Properties. And it is called "Allocated DB Pages"

That information is also available on the database header page, which can be 
extracted by gstat -h

So, basically, with gstat you get everything you need:

* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.