473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

"create oracle user" using procedure in oracle

10
hi,
i've one question.
I'm supposed to create oracle user on click of a button using oracle forms.
I'm calling a procedure which i've written in sql+ which is supposed to create the user.
The problem is that i'm able to create user by writing execute immediate statement in the procedure, but i'm not able to grant connect to the user. Hence i'm getting "admin option not granted for role connect." error.
Is it that the admin_option needs to be yes for a user? The user that i'm using to create a new user has a DBA access.
Isnt this sufficient. Could anyone pls help me on this?

Thanks,
maanasa
Aug 23 '07 #1
6 6680
debasisdas
8,127 Expert 4TB
please try to execute the procedure from sys user.
Aug 23 '07 #2
maanasa
10
debasisdas thanks for the valuable suggestion.
But we are trying to create an application (using oracle forms) which has many roles. And we'll give access to one role for this menu option. But is it necessary that this user as the same privileges as SYS?(for the appliation). This could be a problem to us as the user who logs into the application is not a SYS but has previleges as that of a DBA and still he shud be able to create a new oracle user. Is this possible. Any Help on this will be appreciated. Hope you got my question.

thanks,
maanasa
Aug 24 '07 #3
debasisdas
8,127 Expert 4TB
debasisdas thanks for the valuable suggestion.
But we are trying to create an application (using oracle forms) which has many roles. And we'll give access to one role for this menu option. But is it necessary that this user as the same privileges as SYS?(for the appliation). This could be a problem to us as the user who logs into the application is not a SYS but has previleges as that of a DBA and still he shud be able to create a new oracle user. Is this possible. Any Help on this will be appreciated. Hope you got my question.

thanks,
maanasa
u need to grant

CREATE USER system previligers with admin option.

to the user.
Aug 30 '07 #4
maanasa
10
Do you mean to say that even the application user should have the system privileges to create the oracle user? Is this really possible via Oracle Forms.
Aug 30 '07 #5
debasisdas
8,127 Expert 4TB
If that is your requirment then u need to implement that logic.
Aug 30 '07 #6
As I see it, you need to grant the permission in a separate query call, if you're using oci8 for the connections it means to write a complete second set of instructions with the grant commands. The problem is, as far as I know you can't use stored procedures for CREATE statements. And if you want to grant permissions you need to grant connect in first place and send the connection with a user made on the dbms and with all permissions before.

I hope being helpful
Nov 22 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: arvee | last post by:
Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred in system.data.dll Additional information: Parameter...
1
by: rotarinn | last post by:
Hi, I am using VisualStudio.NET 2003 trying to connect to an Oracle Database (version 8.0.5). I have created the connection using "Microsoft OleDBProvider for Oracle" and when I click on Test...
1
by: Denzil | last post by:
Hi, I am retrieving my DB values and setting them in the MyRS::DoFieldExchange(CFieldExchange* pFX) function. One of these records is a Long datatype and could be "Null" in the DB table. The...
4
by: Ying Lu | last post by:
Hello, I have a table named "USER" under MySQL database. When I am trying to move tables from MySQL to PostgreSQL, I found that I could not create a table namely "USER". I guess "USER" is a key...
2
by: partybob99 | last post by:
I am trying to call SP_Password from some vb.net code. This should be very straight forward but no matter what I do, I keep getting errors. Here is the code strConnectString = "Data Source=" +...
1
by: pat | last post by:
I know this is a long shot, but is there any way of dumping a bunch of SQL "create table" statements from an existing Access 2003 database, to say for example, convert the database to MySQL/Oracle....
4
by: Peter Kanurer | last post by:
Assume I add in VisualCSharp 2005 References to Oracle.DataAccess AND System.Data.OracleClient to an application. Does this cause problems or can they co-exist in one application ?
0
by: vaibhavsumant | last post by:
<project name="DBCreate" default="usage" basedir="."> <property name="user" value="db2admin"/> <property name="passwd" value="db2admin"/> <property name="dbprefix" value=""/> <property...
11
by: Jan | last post by:
Hi: Here's a problem I've had for a long time. The client is really running out of patience, and I have no answers. Access2003, front- and back-end. Single form with 4 subforms (each...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.