MaxDB users

[Former Member]

Hello all,

I am new here and also I am not professional in MaxDB. I need the report with all DB users and their authorizations/roles. Could someone help how to do this report? e.g

Thanks a lot

[former_member229109]

Hello,

1.

Please review the documents u201CManaging Usersu201D and u201CDatabase usersu201D

In the MAXDB library at

http://maxdb.sap.com/doc/7_7/45/01f20034166c32e10000000a114a6b/content.htm

2.

Review u201CDefinitions of the System Tablesu201D at

http://maxdb.sap.com/doc/7_7/45/2c5756ed062b30e10000000a1553f7/content.htm

One of the DOMAIN System Tables - USERS - contains all database users.

< SQL statement: select * from users >

Also see "ROLEPRIVILEGES" at http://maxdb.sap.com/doc/7_7/e9/83a54dbf8945339f652704a3c90ce7/content.htm

"ROLES" at http://maxdb.sap.com/doc/7_7/d7/03c78e146b48b983d31766c77c5df7/content.htm

Regards, Natalia Khlopina

[Former Member]

Thanks for the help. I used the following select:

SELECT owner, username

FROM DOMAIN.USERS

WHERE usermode = 'STANDARD'

but the DB said that there are no results. What I need is the list of all users which are on DB level. Could you see the problem or the hint?

Thanks a lot

Lucia

[former_member229109]

Hello Lucia,

you thread is closed, so I thought that it solved.

If you closed thread, then I recommend to create the new one for the following up questions.

Hints:

• Run statement "select * from users" and check what users you have in the database and if you created DBA | RESOURCE | STANDARD database users.

or

run SQL statements:

sql_execute SELECT owner, username FROM DOMAIN.USERS WHERE usermode = 'DBA'

sql_execute SELECT owner, username FROM DOMAIN.USERS WHERE usermode = ' RESOURCE '

< you posted that you have not STANDARD database users in the database >

• See documentation at MAXDB library:

"Database Users" - http://maxdb.sap.com/doc/7_7/44/c4afa37ca22e17e10000000a114a6b/content.htm

Regards, Natalia Khlopina

[Former Member]

Hi,

Open Database manager at OS level -> Configuration -> Find the users under "Database User" and find the authoraztions under "DBM Operators"

Best regards,

Orkun Gedik

[Former Member]

Thanks a lot. I will try this. Just one question, it is not possible with select?

Lucia

[Former Member]

Try the query given,

http://wiki.sdn.sap.com/wiki/display/MaxDB/User+Concept

Thanks