Consultor Eletrônico



Kbase P9887: How to set permissions on the _user metaschema table?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   30/01/2003
Status: Unverified

GOAL:

How to prevent users other than the Administrator from creating, deleting, dumping and loading _user database records?

FIX:

From the Data Administration Tool, access the Admin -> Security -> Edit Data Security... menu, turn on the Show Hidden tables toggle-box, select the _user metaschema table and set the following permissions on it:

Can-Read: !,*
Can-Write: !,*
Can-Create: administrator
Can-Delete: administrator
Can-Dump: administrator
Can-Load: administrator