473,545 Members | 1,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

IMPORT with REPLACE piveleges needed

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
2 1602
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*****@tabber t.net> a écrit dans le message de
news:11******** **************@ f14g2000cwb.goo glegroups.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
Did the priveleges needed to do a IMPORT with REPLACE change from 7.x
to 8.x?

Nov 12 '05 #3

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

Similar topics

4
7269
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 want is for test1.py and test2.py to be able to import their parent "submodule" as part of a regression
3
2137
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 text line. For example position 5 - 10 in field A, position 20-23 in field B, etc Regards,
5
11548
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 correct once the data is in Access (or during the import process itself). Furthermore, the text files are poorly set up, such that some records may be...
4
3011
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 coming to a firm conclusion over whether it was the better approach, and wonder if I should do it differently the next time I'm faced with a similar...
23
6399
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 process. Currently, my process is I change code and later scan my changes to make matching changes to the import statements. The scan step is error...
10
2635
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 filename
1
4377
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, so were replaced in the master table as a result of the import. For the replica database table, the "deleted" rows were not removed; they still...
2
4516
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 file has several columns that for the most part are fixed length but.. The fixed format starts with a variable length number( char 10) as the first...
5
2756
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 exchanges. The problem is that some of the files I read/write are python files so that, before embedding, I imported them as modules when I needed...
0
7457
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...
0
7391
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...
0
7651
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. ...
1
7410
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
5962
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...
0
4941
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3438
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1010
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
693
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...

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.