Skip to content

lqjack/ue

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ojdbc6.jar
jta.jar
jmscommon.jar
aqapi.jar



Create Users and Grant Permissions

Create users in the database and grant them AQ JMS permissions. Use a database user with administrator privileges to perform the following task:

Using the Oracle SQL*Plus environment, log in with an administrator login.

connect / as sysdba;

Create the JMS user schema. For the following example, 
the user name is GGATE and the password is GGATE.

//create user GGATE identified by GGATE default tablespace GGATE quota 10m on GGATE temporary tablespace temp;    

Grant connect, resource TO GGATE IDENTIFIED BY GGATE;
--Grant the AQ user role to GGATE.
Grant aq_user_role TO GGATE;
--Grant execute privileges to AQ packages
Grant execute ON sys.dbms_aqadm TO GGATE;
Grant execute ON sys.dbms_aq TO GGATE;
Grant execute ON sys.dbms_aqin TO GGATE;
Grant execute ON sys.dbms_aqjms TO GGATE;


mvn install:install-file -Dfile={Path/to/your/ojdbc.jar} -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0 -Dpackaging=jar

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages