Toad World® Forums

new data pump interface has harsh permissions error response


#1

Hi folks,

With TOAD 10.5.1.3 I created a new user in 10gR2 with connect and resource and
read and write on a directory and went to run the new datapump interface.

Turns out you must have select permission on V$PARAMETER to use the new
interface - which is fine.

But rather than nicely telling you that, instead TOAD throws the generic error
(big ole red X error box) and suggests you restart the application twice.

Cheers,

Paul


This email was scanned by MessageLabs



#2

A m ore generic way to state this might be as follows: when using advanced toad
functions (especially ones in DBA module), select catalog role is a must –
else you will encounter various error messages along the way ….


#3

I’ve got my “Ranting DBA” hat on again!!!

With TOAD 10.5.1.3 I created a new user in 10gR2 with
connect and resource …

Without looking it up who knows exactly what privileges those two
roles permit on a 10g database?

How about a 9i database?

No? Neither do I. And that’s why I never allow those roles to be granted
by any vendor (I especially “love” please grant dba, connect and
resource statements in installation instructions) on any database that I
look after here. It’s usually just laziness as the vendor can’t be
bothered to figure out exactly what privileges are actually required.

Cheers,
Norm. [TeamT]

PS. Paul, don’t take it personally, I’m not ranting at you! Just ranting
in general.

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#4

So you’ve dropped those roles completely from the database? If so,
wondering how often someone gets upset that they’re ‘missing’
J


#5

Hi Jeff,

So you’ve dropped those roles completely from the database?
If so, wondering how often someone gets upset that they’re
‘missing’ J

The problem I have is that I’m a Production Support DBA. The databases
are built and set up by other teams long before we get our sticky hands
on them. By then, it’s all done and dusted.

Occasionally, we get the opportunity to do the installation, but 99% of
the time even that is into an existing database.

It would be nice if we managed to get through to these vendors long
before their laziness became a (potential) problem. Unfortunately, this
is government work…

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#6

… and suggests you restart the application twice.

The message actually suggested you restart the application twice? Strange
message!

Just kidding, I know you probably meant you repeated the process twice :wink:

RAS


#7

Hi Paul,

I changed it so that view is no longer required but will use it if present. I
simply gather some default values from it.