Re: Insufficient privilages creating a SNAPSHOT

Have that.
SQLWKS> select username, privilege from user_sys_privs

     2> 
USERNAME                       PRIVILEGE     
SWFOOTBALL                     CREATE ANY INDEX

SWFOOTBALL                     CREATE ANY PROCEDURE

SWFOOTBALL                     CREATE ANY SYNONYM

SWFOOTBALL                     CREATE ANY TRIGGER

SWFOOTBALL                     CREATE DATABASE LINK

SWFOOTBALL                     CREATE SEQUENCE

SWFOOTBALL                     CREATE SESSION

SWFOOTBALL                     CREATE SNAPSHOT

SWFOOTBALL                     CREATE TABLE

SWFOOTBALL                     CREATE TRIGGER

SWFOOTBALL                     DELETE ANY TABLE

SWFOOTBALL                     DROP ANY INDEX

SWFOOTBALL                     DROP ANY TRIGGER

SWFOOTBALL                     INSERT ANY TABLE

SWFOOTBALL                     SELECT ANY SEQUENCE

SWFOOTBALL                     SELECT ANY TABLE

SWFOOTBALL                     UNLIMITED TABLESPACE

SWFOOTBALL                     UPDATE ANY TABLE 

On Tue, 16 Nov 1999 02:58:46 GMT, yewpc_at_my-deja.com wrote:

>Just try to grant create snapshot and create trigger to the creater.
>
>In article <38304166.9577418_at_news.earthlink.net>,
> andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
>> SQLWKS> create snapshot player
>> 2> tablespace swfootballdat
>> 3> storage (INITIAL 100K NEXT 50K)
>> 4> using INDEX tablespace swfootballind
>> 5> REFRESH FAST
>> 6> AS
>> 7> SELECT * FROM PLAYER_at_swfootball_link
>> 8>
>> SELECT * FROM PLAYER_at_swfootball_link
>> *
>> ORA-01031: insufficient privileges
>>
>> Any ideas?
>> Create table as select * from player_at_swfootbal_link works.
>>
>> Thanx
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email