1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| {------------------------------------------------------------------------------}
{
SYSGRANT.per : Administration du System Catalog (SYSTABAUTH et SYSUSERS)
AUTEUR : IFA2377
DATE : 13 Avril 2000
}
{------------------------------------------------------------------------------}
database my_bdd
screen
{
+------------------------------------------------------------------------------+
| |
|grantor [SC1 ] username [SC5 ] |
|grantee [SC2 ] usertype [S] |
|tabid [SC3 ] priority [SC7 ] |
|tabauth [SC4 ] password [SC8 ] |
| |
+------------------------------------------------------------------------------+
}
end
tables SYSTABAUTH
SYSUSERS
attributes
SC1 = SYSTABAUTH.grantor,reverse,noentry,noupdate;
SC2 = SYSTABAUTH.grantee,reverse,noentry,noupdate;
SC3 = SYSTABAUTH.tabid,right,reverse,noentry,noupdate;
SC4 = SYSTABAUTH.tabauth,reverse,noentry,noupdate;
SC5 = SYSUSERS.username,reverse,noentry,noupdate;
S = SYSUSERS.usertype,reverse,noentry,noupdate;
SC7 = SYSUSERS.priority,right,reverse,noentry,noupdate;
SC8 = SYSUSERS.password,reverse,noentry,noupdate;
INSTRUCTIONS
{ Catalog ---------------------------------------------------------------------}
before editadd editupdate of SYSTABAUTH
abort;
before editadd editupdate of SYSUSERS
abort;
{-----------------------------------} end {-----------------------------------} |
Partager