1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
ibuser.addUser;
//Grant sur toutes les tables
dm.qsql3.Close;
dm.qsql3.SQL.Text:='select distinct RDB$RELATION_NAME tab from rdb$RELATION_FIELDS where RDB$VIEW_CONTEXT is null and RDB$SYSTEM_FLAG = 0';
dm.qsql3.open;
dm.qsql3.First;
while not dm.qsql3.Eof do
begin
try
begin
dm.Command1.CommandText:=' grant select, delete, insert, update, references on '+dm.qsql3.fieldbyname('tab').asstring+' to '+ tuserid_Utilisateur.Value;
dm.Command1.Execute;
dm.qsql3.next;
end;
except
dm.qsql3.next;
end;
end; |
Partager