FilesExpand file tree

 master

/

armemo.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

10 lines (9 loc) · 253 Bytes

 master

/

armemo.sql

Copy path

Top

File metadata and controls

• Code
• Blame

10 lines (9 loc) · 253 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

CREATE OR REPLACE VIEW armemo AS

SELECT aropen_id, aropen_docnumber

FROM aropen

WHERE aropen_doctype IN ('D', 'C', 'R')

UNION

SELECT cmhead_id, cmhead_number

FROM cmhead;

REVOKE ALL ON TABLE armemo FROM PUBLIC;

GRANT ALL ON TABLE armemo TO xtrole;