IMPORT with REPLACE piveleges needed

stabbert

Can anyone confirm that the privelges needed to do an IMPORT with
REPLACE have changed from 7.x to 8.x in DB2 UDB? I am finding the
following definition in the online books for version 8 of DB2. I
thought that the last line of only needing INSERT, SELECT and DELETE
was not present in the security definition for this operation in v7,
anyone confirm? The reason I am asking is we have some user id's that
have control privelges on tables for what I remember being to
specifically being able to do an IMPORT with REPLACE. It would appear
they no longer need the CONTROL privelege anymore.

IMPORT to an existing table using the REPLACE or REPLACE_CREATE option,
requires one of the following:
- sysadm
- dbadm
- CONTROL privilege on the table or view
- INSERT, SELECT, and DELETE privilege on the table or view

Spencer

Nov 12 '05 #1

Subscribe Post Reply

1595

Pierre Saint-Jacques

If I understand and know my privileges correctly, this should read:
For IMPORT ... REPLACE_CREATE: CONTROL privilege on the table or view
would be the minimum required as the table/view is dropped..
For IMPORT ... REPLACE: DELETE and INSERT should be the
minimum required.
Obviously, if one is DBADM or SYSADM then those privileges are there by
default.

HTH, Pierre.

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"stabbert" <sp*****@tabbert.net> a écrit dans le message de
news:11**********************@f14g2000cwb.googlegr oups.com...

Can anyone confirm that the privelges needed to do an IMPORT with
REPLACE have changed from 7.x to 8.x in DB2 UDB? I am finding the
following definition in the online books for version 8 of DB2. I
thought that the last line of only needing INSERT, SELECT and DELETE
was not present in the security definition for this operation in v7,
anyone confirm? The reason I am asking is we have some user id's that
have control privelges on tables for what I remember being to
specifically being able to do an IMPORT with REPLACE. It would appear
they no longer need the CONTROL privelege anymore.

IMPORT to an existing table using the REPLACE or REPLACE_CREATE option,
requires one of the following:
- sysadm
- dbadm
- CONTROL privilege on the table or view
- INSERT, SELECT, and DELETE privilege on the table or view

Spencer

Nov 12 '05 #2

stabbert

Did the priveleges needed to do a IMPORT with REPLACE change from 7.x
to 8.x?

Nov 12 '05 #3

Similar topics

Import a module from parent package

by: Peter L. Buschman | last post by:

I have a package tree laid out like this foo/bar/module/submodule foo/bar/module/submodule/test foo/bar/module/submodule/test/test1.py foo/bar/module/submodule/test/test2.py .... What I...

Python

Import question

by: Joost | last post by:

Hello, I am using the LOAD DATA INFILE command to import a text file into mysql. However, there is much more text in the file than needed in my tables. How can I make a selection from the...

MySQL Database

Fixed Width Text File Import Programmtically

by: Johnny Meredith | last post by:

I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can...

Microsoft Access / VBA

Import/Normalize strategy - More issues - New thread

by: Steve Jorgensen | last post by:

I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not...

Microsoft Access / VBA

Proposal: Inline Import

by: Shane Hathaway | last post by:

Here's a heretical idea. I'd like a way to import modules at the point where I need the functionality, rather than remember to import ahead of time. This might eliminate a step in my coding...

Python

How can I import a script with an arbitrary name ?

by: leonel.gayard | last post by:

Hi all, I have a script responsible for loading and executing scripts on a daily basis. Something like this: import time t = time.gmtime() filename = t + '-' + t + '-' + t + '.py' import...

Python

Import with replace for replicated table

by: JC | last post by:

I have a table which is replicated for after images only. I tried to do an import using the replace option into the source table with data. For some of the rows, they were not in the import file,...

DB2 Database

DTS question reguarding text import and tranformation

by: lwhite | last post by:

MS SQL 2000 sp4 on WinXp Pro SP2 I am very new to this so please let me know what I can do to make it easier for you to understand the problem. I have a non delimited text file. This text...

Microsoft SQL Server

Import/Create module from buffer

by: Gruik | last post by:

Hi people, I'm currently working on python embedding with C++. My goal is that the C++ part handle files writing/reading so that the Python part only works with buffers. I succeeded in buffer...

Python

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server