Hi, you wrote: > I connect to databse TST in dbmGui and sqlStudio. > > In the sqlStudio I've: > SELECT * FROM DOMAIN.USERS (...) > DBA DBA SYSDBA MULTIPLE ? ? ? DEFAULT 2003-02-07 (...) > DBA DOMAIN DBA MULTIPLE ? ? ? DEFAULT 2003-02-07 (...) > DBA SYS DBA SINGLE ? ? ? DEFAULT 2003-02-07 (...) > DBA TEST DBA MULTIPLE ? ? ? DEFAULT 2003-02-07 (...) > DBA DBM ADMIN MULTIPLE ? ? ? DEFAULT 2003-02-07 (...) > In dbmGui /dbmCli I've: > TST> user_getall > OK > dbm > dba > DOMAIN > massimo > max > Why I've differents between sqlStudio and dbmGui ? > Why dbmGui dont show TEST user also? > Why sqlStudio dont show max and massimo?!?
"DOMAIN.USERS" is not really a table, not even a view, it is a system view which contents depend on the user who looks at it. so looking at it, you would only see the users which (according to some policy) you should see. > Why I can connect via odbc only with DBA and TEST ?! cf. my previous posting to the list. regards, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: Massimo Renzi [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 12:44 PM > To: [EMAIL PROTECTED]; sapdb mlist; Sapdb. General > Subject: [USERS] dbmGui VS sqlStudio > > > Hi all, > I connect to databse TST in dbmGui and sqlStudio. > > In the sqlStudio I've: > SELECT * FROM DOMAIN.USERS > and I've: > [CUT] > DBA DBA SYSDBA MULTIPLE ? ? ? DEFAULT 2003-02-07 > 18:37:06 > 2003-02-07 18:37:06 2003-02-07 18:37:06 TST > localhost.localdomain 10 > ? > DBA DOMAIN DBA MULTIPLE ? ? ? DEFAULT 2003-02-07 > 18:37:07 > 2003-02-07 18:37:10 2003-02-07 18:37:07 TST > localhost.localdomain 11 > ? > DBA SYS DBA SINGLE ? ? ? DEFAULT 2003-02-07 > 18:37:12 > 2003-02-07 18:37:12 2003-02-07 18:37:12 TST > localhost.localdomain 12 > ? > DBA TEST DBA MULTIPLE ? ? ? DEFAULT 2003-02-07 > 18:37:31 > 2003-02-07 18:37:31 2003-02-07 18:37:31 TST > localhost.localdomain 13 > ? > DBA DBM ADMIN MULTIPLE ? ? ? DEFAULT 2003-02-07 > 18:37:06 > 2003-02-07 18:37:06 2003-02-07 18:37:06 TST > localhost.localdomain 0 > ? > [CUT] > > In dbmGui /dbmCli I've: > TST> user_getall > OK > dbm > dba > DOMAIN > massimo > max > > Why I've differents between sqlStudio and dbmGui ? > Why dbmGui dont show TEST user also? > Why sqlStudio dont show max and massimo?!? > > > thank u > > maxsoft > > irc-chat: > server address: LasVegas.NV.US.Undernet.org > server port: 6667 > channel: #sapdb > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
