create assertion?

From: eugene kim <eugene1977_at_hotmail.com>
Date: Sat, 07 Sep 2002 12:43:59 +0000
Message-ID: <alc2u8$1dn$1@newsreader.mailgate.org>

hi..

create assertion price_constraint check

        (not exists 
                (select * from titles
                where max(price) < price));
                

i want to see if this one will work,
max(price) is selected before new price comes in? by the way oracle is giving me error,

---

create assertion price_constraint check

       *
ERROR at line 1:
ORA-00901: invalid CREATE command

---

my first guess was 'create assertion' has to be granted. grant create assertion to user1;
didn't work

i used this..

grant CREATE SESSION,
CREATE TABLE,
CREATE VIEW,
CREATE TRIGGER,
CREATE PROCEDURE,
CREATE SEQUENCE to my_group_role;

one more question..
grant connect, resource to user; is better than specifying in detail?

thanks a lot Received on Sat Sep 07 2002 - 07:43:59 CDT