Re: grant select to another domain user

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 19 Jun 2003 19:23:27 +0200
Message-ID: <nas3fvcishc6nselsf79gfk110n613tipd@4ax.com>

On Thu, 19 Jun 2003 11:29:39 +0000, kfc_at_vd.dk <member31463_at_dbforums.com> wrote:

>
>Hi
>How do I grant select on a table to a user in another domain?
>
>I have a domain called VDS - here I have a user called USER1 which owns
>a table called TABLE1. In another domain VDSDEMO I have a user called
>USER2. How do I grant properties to this user?
>
>ex:
>
>connect USER1/****@VDS;
>grant select on TABLE1 to ????????;
>
>connect USER2/****@VDSDEMO;
>select * from ????????;

If by 'domain' you mean database: this is not possible. If by 'domain' you mean NT domain: just prefix the domain \\domain\user

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 19 2003 - 12:23:27 CDT