CODEWITHSUNDEEP
selectpermissionsinformix
SuRa
SuRa

Reputation: 513

How to take unload of a table in informix db when table not having SELECT permission?

Is there possibility to take unload of a table when the table is not having SELECT permission.

Upvotes: 1

Views: 1407

Answers (2)

Yuri Levinsky
Yuri Levinsky

Reputation: 1595

Use SPL "system" command to unload data from table where your user doesn't has access rights. This command runs as Informix user which DBA by definition. You can see your file system or delete whole your database by using this nice command. There are couple more another methods to do same.

Upvotes: 0

RET
RET

Reputation: 9188

If you intend to unload the table using either the High Performance Loader or the Informix SQL extension UNLOAD TO file SELECT ..., then no. You'll need to execute the statement as a user with SELECT privileges.

I'm not in a position to verify what would happen with the onunload utility, but I suspect the answer is going to be the same, since I'm pretty sure you need to have elevated privileges (DBA or DBSA) to run that in the first place.

Why do you not have SELECT permission? And if there's a good reason, then you shouldn't be allowed to write the contents of the table to a flat file anyway.

Upvotes: 1

Related Questions