473,701 Members | 2,804 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Create Schema statement failed.

On my DB2 UDB 8.2.7 database user User1 has been granted
IMPLICIT_SCHEMA privilege, but when he issues "create schema test",
the error message "SQL0552N, USER1 does not have the previliege to
execute the operation create schema" was thrown. But if he issues
"create table test.test(a int)", the operation can execute
successfully. So how can I let users issue the create schema statement.

Feb 8 '07 #1
2 10834
Can u list us the authorizations that the user has?
On Feb 8, 8:11 am, "Amber" <guxiaobo1...@g mail.comwrote:
On my DB2 UDB 8.2.7 database user User1 has been granted
IMPLICIT_SCHEMA privilege, but when he issues "create schema test",
the error message "SQL0552N, USER1 does not have the previliege to
execute the operation create schema" was thrown. But if he issues
"create table test.test(a int)", the operation can execute
successfully. So how can I let users issue the create schema statement.

Feb 8 '07 #2
Ian
Amber wrote:
On my DB2 UDB 8.2.7 database user User1 has been granted
IMPLICIT_SCHEMA privilege, but when he issues "create schema test",
the error message "SQL0552N, USER1 does not have the previliege to
execute the operation create schema" was thrown. But if he issues
"create table test.test(a int)", the operation can execute
successfully. So how can I let users issue the create schema statement.

Unless a user has DBADM or SYSADM, they can only create a schema
explicitly if the schema name is the same as their auth ID.

i.e.

$ db2 connect to mydb

Database Connection Information

Database server = DB2/6000 8.2.2
SQL authorization ID = IANBJOR
Local database alias = MYDB
$ db2 create schema x
DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:
SQL0552N "IANBJOR" does not have the privilege to perform operation
"CREATE SCHEMA". SQLSTATE=42502

$ db2 create schema ianbjor
DB20000I The SQL command completed successfully.

See the documentation for CREATE SCHEMA:

http://publib.boulder.ibm.com/infoce...n/r0000925.htm

Ian
Feb 9 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
8097
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure creates a string of custom SQL statement and returns this string back to the main stored procedure. This SQL statements work fine on there own. The SQL returned from the sub stored procedure are returned fine. The datatype of the variable that...
6
2588
by: Martin | last post by:
Hi, I have a xml file like the one below <?xml version="1.0" encoding="utf-8"?><e1 xmlns:e1="http://tempuri.org/Source1.xsd" e1:att1="1" e1:att2="2" e1:rest="345"/> If I try to create a schema for it with Visual Studio, I get the error "Failed to create a schema for this data file because:
7
8862
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
0
1039
by: PeterS | last post by:
I am trying to create new web service for existing schema by using BizTalk Web Services Publishing Wizard. By clicking create button I got the following error message Web Access Failed The default Web access mode for this project is set to file share, but the project folder at ‘http://localhost/AccidentInvest_Info' cannot be opened with the path ‘C:\Solution\Accident Solution\Accident Solution\AccidentInvest_Info'. The error returned was:...
10
8816
by: Zack Sessions | last post by:
Has anyone tried to create a SQL7 view using the CREATE VIEW command and ADO.NET? If so, is there a trick in trapping a SQL error when trying to create the view? I have a VB.NET app that, amoung other things, can create views based on existing tables and a table of column name equivalents. If I accidently introduce a column name equivalent that is the same as another column, I end up with a CREATE VIEW SQL statement that is in error, if...
3
1695
by: Seamus Thomas Carroll | last post by:
Hi, I am trying to create a schema where the schema name has been defined in another table. My sql looks like: create schema (select agent_schema from agents.agents where agent_id = (select(last_value) from agents.agents_seq)); The select statement works correctly on its own but when added to "create schema" I get the following error: ERROR: syntax error at or near "(" at character 15
2
22610
by: masri999 | last post by:
I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables . Developer's should not create or alter tables . 3. Developers can create/alter Stored Procedure/User Defined functions in dbo schema and can execute SP/UDF. 4. Developers should have SELECT,INSERT,DELETE,UPDATE on tables ( tables in dbo schema
3
6677
by: Rahul B | last post by:
Hi, I have a user UCLDEV1 which is a part of staff and a group(db2schemagrp1) to which i have not given any permissions. The authorizations of that user are shown as db2 =get authorizations Administrative Authorizations for Current User
0
8982
debasisdas
by: debasisdas | last post by:
The following script is used to create a read only schema of any existing schema in the same database. The readonly schema is granted only read permisions on the tables and views of the existing schema. No previliges on any other objects. The script can be customized as per requirment. CREATE OR REPLACE PROCEDURE CREATE_READONLY_SCHEMA ( i_owner IN VARCHAR2, i_readonly IN VARCHAR2 ) IS CURSOR cur_c1
0
8737
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8649
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9232
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9084
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7827
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6573
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3104
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2399
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2036
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.