Database access

[Former Member]

hi all

I want to access database through sqlplus. how can i get it and i want to see the table like vbak, lips etc.

how can i see that.

and i want to delete one user from database.

[andreas_herzog]

hi,

invoke sqlplus on os level (user ora<sid>on unix, user <sid>adm on windows) by typing

> sqlplus /nolog

connect to your db by using

> connect / as sysdba

tables will ba accessed by using queries like

> desc sapr3.vbak (or SAP<Schema-ID>.tablename)

> select * from sapr3.vbak and so on...

user deletion...sap user or a database user? sap user information usually reside in table usr02 (client dependent!)...so

> delete from sapr3.usr02 where bname = 'USERNAME' and mandt = 'CLIENT number';

> commit

GreetZ, AH