table privs via roles

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Fri, 25 Jun 1999 13:59:01 GMT
Message-ID: <7l01ut$4lp$1@nnrp1.deja.com>

Greetings All,

I have exported all of a user's objects from one database. I then created a user of the same name in another database and granted that user connect, resource and dba roles. I then attempted to import the user's objects from the export. All of the views for this new user have errors, I get a message about not being able to create views based on tables where those privs were via roles (or something very close).

I've just read a bit about this in the Oracle DBA handbook, I THINK it suggests that the privilege must be explicitly granted on each table to this new user. What have I missed out? There must be an easy way to "copy" a user from one db to another using exp / imp, I'm sure I've done it before (but not on a Friday afternoon! :) )

Any tips / a kick in the right direction would be helpful,

Thanks in advance

Tony

PS Oracle 7.3.4

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 08:59:01 CDT