Solved

Oracle Express XE 11g R2 how to create and set pivileges to CONNECT ROLE

Posted on 2013-01-14
2
1,263 Views
Last Modified: 2013-01-14
Hi Experts,

I need to CREATE a CONNECT role using Oracle Express 11g R2

once created  neet to CREATE privileges as follows :
GRANT CREATE SESSION TO "CONNECT";
GRANT CREATE TABLE TO "CONNECT";
GRANT CREATE VIEW TO "CONNECT";
GRANT CREATE SYNONYM TO "CONNECT";
GRANT CREATE DATABASE LINK TO "CONNECT";
GRANT CREATE CLUSTER TO "CONNECT";
GRANT CREATE SEQUENCE TO "CONNECT";
GRANT ALTER SESSION TO "CONNECT";

Am thinking the above is correct SQL syntax.
The only available way to mod 11.2g seems to be through SQL command line.

Please advise on the create CONNECT role syntax

Thanks Lfromant
0
Comment
Question by:lfromant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
Docteur_Z earned 500 total points
ID: 38773677
Hi,
You're on the right way.
See examples from documentation :
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_6012.htm#SQLRF01311
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9013.htm#SQLRF01603

But for security reasons, I wouldn't give as much rigths to a role which is meant for connection. I'd add another role for schema property.
0
 

Author Closing Comment

by:lfromant
ID: 38773699
Thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question