Re: Transferring a Database using Toad

From: Dale Edgar <dale_at_databee.com>
Date: Wed, 23 Jan 2002 07:23:09 GMT
Message-ID: <3c4e640d.2443587@news.btclick.com>

Hi Dan

On Wed, 23 Jan 2002 04:05:17 GMT, "dan m" <danmetzger_at_att.net> wrote:

>When you do the full export using "exp", does this also export the users
>(connectivity such as passwords and roles granted to those who connect) in
>the database or just the schemas?

You get the users, roles, public synonyms, and public database links. If you are interested in digging this information out of an exp file (all roles for a user, all grants to a role, or all public synonyms) then you might want to check out the freeware DBATool

DBATool: http://www.databee.com/dt_home.htm

Regards
Dale Edgar
Net 2000 Ltd.
Dale_at_DataBee.com Received on Wed Jan 23 2002 - 01:23:09 CST