views?

[rlowe]

I am trying to create a view from one users schema to anothers. example:

CREATE VIEW daily_domain AS SELECT processdate from usage.raddaily_domain;

the error i get says that this table or view does not exist.

HOWEVER, when I run the query

SELECT * FROM usage.raddaily_domain;

I get results. Is there something I need to do before I can create this view?

Thanks.

[Sairaj]

Hi
You may have only select privileges. Check for the privileges on that table.

Prasad

[jdorlon]

I think you need to have the privileges granted directly to your user id, not through a role.

-John

[gsprince]

Try granting the "SELECT" privilege explicitly (not thru ROLES) to the user and then try creating the view.

[rlowe]

thanks.

It turns out that select permissions do need to be granted explicitly to the user,not role.

once again,thanks