Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-01-14
2
Medium Priority
?
1,287 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 1500 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

670 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