Consultor Eletrônico



Kbase P108276: Does _user table concept in Progress apply to oracle DataServer schema holder?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   29/11/2005
Status: Unverified

GOAL:

Does _user table concept in Progress apply to oracle DataServer schema holder?

GOAL:

Can I edit _user table against Oracle image?

GOAL:

How should I apply security in Oracle for Oracle data server?

FACT(s) (Environment):

Oracle DataServer

FIX:

_user table is a way to implement database security for Progress databases. You can not edit _user table against an Oracle image.
To apply security in Oracle database, use Oracle tools. For example, all users must supply a valid user ID and password to access an ORACLE database. In addition, ORACLE provides security in the form of distinct privileges that control access to databases and objects within databases. ORACLE regulates access to database objects at the table level based on types of tasks. For example, INDEX privileges allow the user to create or drop indexes.