Re: A question about creating the user only for export and import database

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 11 Apr 2002 12:41:33 +0200
Message-ID: <3CB5685D.5381EDB9@mytoys.de>

Wow, Britney Spears is using Oracle!

> How can I create the user with limited privileges only for export and
> import the database ?
> I means the user can not create and view table just for backup the
> oracle database .

How shall a user export (=read the data and write it to a dump file) data without the privilege to read the data? Of course you create a user with just reading privs on the desired tables (grant select on <table_name> to <user>) but at least reading has to be possible.

Regards,

Knut Received on Thu Apr 11 2002 - 05:41:33 CDT