MQSeries.net :: View topic - Oracle authority for WMB

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle authority for WMB

Oracle authority for WMB

« View previous topic :: View next topic »

Author

Message

crossland

Posted: Wed Jan 10, 2007 9:27 am Post subject: Oracle authority for WMB

Master

Joined: 26 Jun 2001
Posts: 248

As part of the installation of WMB, the database userid needs to be granted CONNECT, GRANT and CREATE TABLE. What is the command to check if this has been done?

nab054371

Posted: Wed Jan 10, 2007 5:50 pm Post subject:

Disciple

Joined: 15 Nov 2006
Posts: 173

Are you using oracle ?
If so,you should be able to check oracle grants/priviliges on that user using Oracle Data dictionary

You could look up following tables in Oracle for your broker userid:

dba_role_privs
dba_sys_privs
dba_users
role_role_privs
role_sys_privs
role_tab_privs

crossland

Posted: Thu Jan 11, 2007 6:22 am Post subject:

Master

Joined: 26 Jun 2001
Posts: 248

Oracle is being used.

From the list of tables supplied, the only one that produced any results was the following:

SQL> select * from role_sys_privs;

ROLE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE SESSION NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE TABLE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE INDEXTYPE NO

Is there any way to determine which privileges have been granted to a user?

jefflowrey

Posted: Thu Jan 11, 2007 6:26 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Ask your Oracle administrator...

run mqsicreatebroker and see if it fails...
_________________
I am *not* the model of the modern major general.

nab054371

Posted: Thu Jan 11, 2007 6:31 am Post subject:

Disciple

Joined: 15 Nov 2006
Posts: 173

try this:
http://www.psoug.org/reference/system_privs.html

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle authority for WMB

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP