Neoview SQL Reference Manual (R2.4)

PRIVILEGES Option
The PRIVILEGES option includes the GRANT statements as they apply to the option. Each
privilege is specified in a separate GRANT even if they were granted in a single statement. For
example:
GRANT ALL PRIVILEGES ON TABLE t1 TO “role_user1”, “role_user2”:
will be displayed as:
GRANT SELECT ON TABLE sch.t1 TO "role_user1";
GRANT UPDATE ON TABLE sch.t1 TO "role_user1";
GRANT DELETE ON TABLE sch.t1 TO "role_user1";
GRANT INSERT ON TABLE sch.t1 TO "role_user1";
GRANT REFERENCES ON TABLE sch.t1 TO "role_user1";
GRANT SELECT ON TABLE sch.t1 TO "role_user2";
GRANT UPDATE ON TABLE sch.t1 TO "role_user21";
GRANT DELETE ON TABLE sch.t1 TO "role_user21";
GRANT INSERT ON TABLE sch.t1 TO "role_user2";
GRANT REFERENCES ON TABLE sch.t1 TO "role_user2";
Examples of SHOWDDL
• SHOWDDL with no options:
-- Create a table
set schema neo.sch;
create table t1
( c1 int not null
, c2 int not null
, c3 char (30) NOT CASESPECIFIC
, c4 date default current_date
, c5 largeint generated by default as identity
, primary key (c2, c1))
partition by (c1)
max table size 2000;
-- showddl
SHOWDDL T1;
-- showddl output
CREATE TABLE SCH.T1
(
C1 INT NO DEFAULT -- NOT NULL
, C2 INT NO DEFAULT -- NOT NULL
, C3 CHAR(30) CHARACTER SET ISO88591 NOT
CASESPECIFIC DEFAULT NULL
, C4 DATE DEFAULT CURRENT_DATE
, C5 LARGEINT GENERATED BY DEFAULT AS IDENTITY
-- NOT NULL
, CONSTRAINT SCH.T1_985546634_1496 PRIMARY KEY (C2 ASC, C1 ASC)
, CONSTRAINT SCH.T1_491636634_1496 CHECK (SCH.T1.C1 IS NOT NULL AND
SCH.T1.C2 IS NOT NULL AND SCH.T1.C3 IS NOT NULL AND SCH.T1.C5
IS NOT NULL)
)
HASH PARTITION BY (C1)
MAX TABLE SIZE 2000
;
-- Create a view
Create view t1_view as select c2, c3 from t1 where c1 > 0;
-- showddl
SHOWDDL T1_VIEW;
-- showddl output
SHOWDDL Statement 193