"Bumes, Hans-Georg" schrieb:
Andre Reitz wrote:
> USE USER DBA DBA;
> CATALOGLOAD ALL INFILE '/tmp/cat.dmp'
> What exactly is a sysdba?
> / E -25331: This is a restricted statement, user must be SYSDBA.
> I created my DBA as in the create_demodb script:
> util_connect DBM,pwd
> util_execute init config
> util_activate DBA,DBA
> What about the user "SYS"?
can you please send me the resultset of the statement
select * from domain.users
executed in your dba dba session?
--
Hans-Georg Bumes
SAP DB, SAP Labs Berlin
http://www.sapdb.org/
 
>>> select * from domain.users;

  OWNER GROUPNAME USERNAME USERMODE CONNECTMODE PERMLIMIT TEMPLIMIT MAXTIMEOUT COSTWARNING COSTLIMIT CREATEDATE CREATETIME ALTERDATE ALTERTIME PWCREADATE PWCREATIME SERVERDB SERVERNODE USER_ID COMMENT
  ----------------------------------------------------------------------------------------------------------------------------------------------------------------
  DBA  DBA    SYSDBA   MULTIPLE NULL NULL NULL NULL NULL 20020213 00161531 20020213 00161531 20020213 00161531 INWORKSM moon 10 NULL
  DBA  DOMAIN DBA      SINGLE   NULL NULL NULL NULL NULL 20020213 00161531 20020213 00161531 20020213 00161531 INWORKSM moon 11 NULL
  DBA  SYS    DBA      SINGLE   NULL NULL NULL NULL NULL 20020213 00161532 20020213 00161532 20020213 00161532 INWORKSM moon 12 NULL
  DBA  DBM    COLDUSER MULTIPLE NULL NULL NULL NULL NULL 20020213 00161531 20020213 00161531 20020213 00161531 INWORKSM moon 0 NULL
 
 

 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general


-- 
_____________________________________________
inworks GmbH            Andre Reitz             
Magirusstrasse 44       Tel. 0731/93 80 7-21
89077 Ulm               http://www.inworks.de

 

Reply via email to