Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADIBSecurity Class
public  published  TADIBSecurity Members  Example 1  Example 2  Example 3  Classes  Send Feedback

The class implementing FB/IB database security management service.

Group

Classes

Class Hierarchy
uADPhysIB_TADIBSecurityuADPhysIB_TADIBSecurityuADPhysIB_TADIBSecurity
File

uADPhysIB

Links
public, published, TADIBSecurity Members, Example 1, Example 2, Example 3, Classes
Description

Use the TADIBSecurity component to add a database security management capabilities to an application. 

To manage a security an application should:

Syntax
TADIBSecurity = class(TADIBService);
Example 1

Adding a user: 

ADIBSecurity1.DriverLink := ADPhysIBDriverLink1;

ADIBSecurity1.UserName := 'sysdba';
ADIBSecurity1.Password := 'masterkey';
ADIBSecurity1.Host := 'db_srv_host';
ADIBSecurity1.Protocol := ipTCPIP;

ADIBSecurity1.AUserName := 'user1';
ADIBSecurity1.APassword := '12345';
ADIBSecurity1.AFirstName := 'Bill';
ADIBSecurity1.ALastName := 'Scott';

ADIBSecurity1.AddUser;
Example 2

Change a user password: 

ADIBSecurity1.DriverLink := ADPhysIBDriverLink1;

ADIBSecurity1.UserName := 'sysdba';
ADIBSecurity1.Password := 'masterkey';
ADIBSecurity1.Host := 'db_srv_host';
ADIBSecurity1.Protocol := ipTCPIP;

ADIBSecurity1.AUserName := 'user1';
ADIBSecurity1.APassword := '12345';

ADIBSecurity1.ModifyUser;
Example 3

List all users using TADMemTable: 

ADIBSecurity1.DriverLink := ADPhysIBDriverLink1;

ADIBSecurity1.UserName := 'sysdba';
ADIBSecurity1.Password := 'masterkey';
ADIBSecurity1.Host := 'db_srv_host';
ADIBSecurity1.Protocol := ipTCPIP;

ADIBSecurity1.DisplayUsers;
ADMemTable1.AttachTable(ADIBSecurity1.Users, nil);
ADMemTable1.Open;
What do you think about this topic? Send feedback!