Re: Grant to create links & views

Julien wrote:

> Hi all,
>
> I'd like to know what is the grant syntax to authorize a user to create
> databases links and tables views.
> Do U know ?
>
> Thx All !

The three link related system privs are: create database link
create public database link
drop public database link

as in: GRANT create database link TO <schema_name>

Though since most DBAs are lazy and grant the CONNECT role to every user ... pretty much every user already has the privilege.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)