hi,

i'd like to know if i can modify or delete some parameters and objects
from the oracle database

if i revoke this grants from user ESECDBA revoke SELECT ANY DYCTIONAR,
DROP ANY DIRECTORY, DROP ANY ROLE, CREATE DIRECTORY. what's could
happend with the sentinel db or with sentinel ?,


in this case is the same if i delete this parameters, what could
happend?, are they necessary? and why?

ESECDBA Create role
ESECDBA Create Public synonym
ESECDBA Create table
ESEC_OWNER Create database link
ESEC_OWNER Create cluster
ESEC_OWNER Create sequence
ESEC_OWNER Create synonym
ESEC_OWNER Create table
ESEC_OWNER Create View

and sentinel need permission over this packages and why ?

'UTL_TCP','UTL_HTTP','UTL_SMTP','DBMS_JOB','DBMS_L OB','UTL_FILE','DBMS_ALERT','DBMS_PIPE','DBMS_DDL' ,'DBMS_DISTRIBUTED_TRUST_ADMIN','DBMS_FGA','DBMS_J OB','DBMS_SCHEDULER','DBMS_LDAP','DBMS_LOGMNR','DB MS_LOGMNR_D','DBMS_OBFUSCATION_TOOLKIT','DBMS_ORAC LE_TRACE_AGENT','DBMS_REPAIR','DBMS_REPCAT','DBMS_ REPCAT_ADMIN','DBMS_RESOUIRCE_MANAGER','DBMS_RESOU RCE_MANAGER_PRIVS','DBMS_RLS','DBMS_SESSION','DBMS _SQL','DBMS_RANDOM','DBMS_LOB','DBMS_BACKUP_RESTOR E','DBMS_FILE_TRANSFER','DBMS_SYS_SQL','DEBUG_EXTP ROC','PBSDE','UTL_FILE','UTL_HTTP','UTL_REF','UTL_ SMTP','UTL_TCP','DBMS_REPCAT_INSTANTIATE','MD2','S DO_ADMIN','OWA_UTIL','DBSM_NAMESPACE','EMD_SYSTEM' ,'DBMS_METADATA','DRILOAD','CTX_DOC','UTL_INADDR', 'DBMS_SQL','UTL_FILE','DBMS_JOB','DBMS_OBFUSCATION _TOOLKIT','DBMS_SCHEDULER','DBMS_SQL

the same these users are necessary and why?
ESEC_APP
ESEC_USER
ESEC_CONNECT
ESEC_ETL
ESEC_OWNER

all this changes will be after the installation of sentinel db in
oracle

thanks for your time,
regards,

Roberto


--
roda182
------------------------------------------------------------------------
roda182's Profile: http://forums.novell.com/member.php?userid=113591
View this thread: http://forums.novell.com/showthread.php?t=451102