File: grant_select.sql

package info (click to toggle)
virtuoso-opensource 7.2.12%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 299,308 kB
  • sloc: ansic: 655,054; sql: 508,209; xml: 269,573; java: 84,064; javascript: 79,847; cpp: 37,662; sh: 32,429; cs: 25,702; php: 12,690; yacc: 11,666; lex: 7,933; makefile: 7,308; jsp: 4,523; awk: 1,719; perl: 1,013; ruby: 1,003; python: 326
file content (16 lines) | stat: -rw-r--r-- 491 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
create procedure DB.DBA.grant_select()
{
      DB.DBA.USER_CREATE ('SOAP', uuid(), vector ('DISABLED', 1));
      DB.DBA.user_set_qualifier('SOAP', 'WS');
}
;

DB.DBA.grant_select();
grant select on Demo.demo.Customers     to SOAP;
grant select on Demo.demo.Orders        to SOAP;
grant select on Demo.demo.Order_Details to SOAP;
grant select on Demo.demo.Products      to SOAP;
grant select on Demo.demo.Categories    to SOAP;


DB.DBA.exec_no_error ('drop procedure DB.DBA.grant_select');