Solved

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

Posted on 2013-01-14
2
1,243 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
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

773 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