sdbms_sql.v

使用yacc的一个例子

	.  reduce 18


state 34
	sql : revoke2 .  (19)

	.  reduce 19


state 35
	sql : set_user_seclevel .  (20)

	.  reduce 20


state 36
	sql : set_table_seclevel .  (21)

	.  reduce 21


state 37
	sql : set_allow_seclevel .  (22)

	.  reduce 22


state 38
	sql : set_current_seclevel .  (23)

	.  reduce 23


state 39
	sql : create_table .  (24)

	.  reduce 24


state 40
	sql : drop_table .  (25)

	.  reduce 25


state 41
	sql : insert .  (26)

	.  reduce 26


state 42
	sql : update .  (27)

	.  reduce 27


state 43
	sql : delete .  (28)

	.  reduce 28


state 44
	sql : select .  (29)

	.  reduce 29


state 45
	sql : audit1 .  (30)

	.  reduce 30


state 46
	sql : noaudit1 .  (31)

	.  reduce 31


state 47
	sql : audit2 .  (32)

	.  reduce 32


state 48
	sql : noaudit2 .  (33)

	.  reduce 33


state 49
	sql : audit3 .  (34)

	.  reduce 34


state 50
	sql : noaudit3 .  (35)

	.  reduce 35


state 51
	username : IDENTIFIER .  (46)

	.  reduce 46


state 52
	connect_database : CONNECT username . WITH PASSWORD password
	connect_database : CONNECT username . TO dbname WITH PASSWORD password

	WITH  shift 136
	TO  shift 137


state 53
	create_role : CREATE ROLE . rolename
	create_role : CREATE ROLE . rolename AS CHILD OF rolename
	create_role : CREATE ROLE . rolename AS PARENT OF rolenames

	IDENTIFIER  shift 138

	rolename goto 139


state 54
	create_database : CREATE DATABASE . dbname

	IDENTIFIER  shift 140

	dbname goto 141


state 55
	create_table : CREATE TABLE . tablename tabcollist
	create_table : CREATE TABLE . tablename tabcollist WITH SECLEVEL seclevel

	IDENTIFIER  shift 132

	tablename goto 142


state 56
	create_user : CREATE USER . username WITH PASSWORD password
	create_user : CREATE USER . username WITH PASSWORD password WITH SECLEVEL class
	create_user : CREATE USER . username WITH PASSWORD password WITH SECLEVEL seclevel

	IDENTIFIER  shift 51

	username goto 143


state 57
	drop_role : DROP ROLE . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 145


state 58
	drop_database : DROP DATABASE . dbname

	IDENTIFIER  shift 140

	dbname goto 146


state 59
	drop_table : DROP TABLE . tablenames

	IDENTIFIER  shift 132

	tablename goto 147
	tablenames goto 148


state 60
	drop_user : DROP USER . usernames

	IDENTIFIER  shift 51

	username goto 149
	usernames goto 150


state 61
	add_user_to_role : ADD USER . usernames TO rolenames

	IDENTIFIER  shift 51

	username goto 149
	usernames goto 151


state 62
	del_user_from_role : DEL USER . usernames FROM rolenames

	IDENTIFIER  shift 51

	username goto 149
	usernames goto 152


state 63
	change_role : CHANGE USER . usernames TO rolenames

	IDENTIFIER  shift 51

	username goto 149
	usernames goto 153


state 64
	systemright : CREATE . DATABASE
	systemright : CREATE . TABLE
	systemright : CREATE . VIEW
	systemright : CREATE . INDEX

	DATABASE  shift 154
	TABLE  shift 155
	VIEW  shift 156
	INDEX  shift 157


state 65
	systemright : DROP . DATABASE
	systemright : DROP . TABLE
	systemright : DROP . VIEW
	systemright : DROP . INDEX

	DATABASE  shift 158
	TABLE  shift 159
	VIEW  shift 160
	INDEX  shift 161


state 66
	systemright : GRANT .  (75)

	.  reduce 75


state 67
	systemright : REVOKE .  (76)

	.  reduce 76


state 68
	operation : SELECT .  (85)
	operation : SELECT . '(' fieldnames ')'

	'('  shift 162
	.  reduce 85


state 69
	operation : INSERT .  (87)
	operation : INSERT . '(' fieldnames ')'

	'('  shift 163
	.  reduce 87


state 70
	operation : UPDATE .  (89)
	operation : UPDATE . '(' fieldnames ')'

	'('  shift 164
	.  reduce 89


state 71
	operation : YDELETE .  (91)
	operation : YDELETE . '(' fieldnames ')'

	'('  shift 165
	.  reduce 91


state 72
	systemrights : systemright .  (66)

	.  reduce 66


state 73
	grant1 : GRANT systemrights . TO rolenames
	systemrights : systemrights . ',' systemright

	','  shift 166
	TO  shift 167


state 74
	grant2 : GRANT operations . where_clause ON tablename TO rolenames
	grant2 : GRANT operations . where_clause ON tablename TO rolenames WITH GRANT OPTION
	operations : operations . ',' operation
	where_clause : .  (192)

	','  shift 168
	WHERE  shift 169
	.  reduce 192

	where_clause goto 170


state 75
	operations : operation .  (84)

	.  reduce 84


state 76
	systemright : GRANT .  (75)
	revoke2 : REVOKE GRANT . OPTION FOR operations where_clause FROM tablename TO rolenames

	OPTION  shift 171
	.  reduce 75


state 77
	revoke1 : REVOKE systemrights . FROM rolenames
	systemrights : systemrights . ',' systemright

	','  shift 166
	FROM  shift 172


state 78
	revoke2 : REVOKE operations . where_clause ON tablename FROM rolenames
	revoke2 : REVOKE operations . where_clause ON tablename FROM rolenames CASCADE
	revoke2 : REVOKE operations . where_clause ON tablename FROM rolenames RESTRICT
	operations : operations . ',' operation
	where_clause : .  (192)

	','  shift 168
	WHERE  shift 169
	.  reduce 192

	where_clause goto 173


state 79
	set_child_role : SET CHILD . ROLE rolenames OF rolename

	ROLE  shift 174


state 80
	set_parent_role : SET PARENT . ROLE rolename OF rolenames

	ROLE  shift 175


state 81
	set_top_role : SET TOP . ROLE rolenames

	ROLE  shift 176


state 82
	set_user_seclevel : SET SECURITY . LEVEL class TO usernames
	set_user_seclevel : SET SECURITY . LEVEL seclevel TO usernames
	set_table_seclevel : SET SECURITY . LEVEL seclevel ON tablenames

	LEVEL  shift 177


state 83
	set_allow_seclevel : SET ALLOW . SECURITY LEVEL seclevel ON tablenames TO usernames

	SECURITY  shift 178


state 84
	set_current_seclevel : SET CURRENT . SECURITY LEVEL seclevel ON tablenames TO usernames

	SECURITY  shift 179


state 85
	systemright : CREATE . DATABASE
	systemright : CREATE . TABLE
	systemright : CREATE . VIEW
	systemright : CREATE . INDEX
	security_right : CREATE . USER
	security_right : CREATE . ROLE

	ROLE  shift 180
	DATABASE  shift 154
	TABLE  shift 155
	VIEW  shift 156
	INDEX  shift 157
	USER  shift 181


state 86
	systemright : DROP . DATABASE
	systemright : DROP . TABLE
	systemright : DROP . VIEW
	systemright : DROP . INDEX
	security_right : DROP . USER
	security_right : DROP . ROLE

	ROLE  shift 182
	DATABASE  shift 158
	TABLE  shift 159
	VIEW  shift 160
	INDEX  shift 161
	USER  shift 183


state 87
	security_right : ADD . ROLE

	ROLE  shift 184


state 88
	security_right : DEL . ROLE

	ROLE  shift 185


state 89
	security_right : CHANGE . ROLE

	ROLE  shift 186


state 90
	executor : ROLE . '(' rolenames ')'
	executor : ROLE . '(' rolenames ')' ',' USER '(' usernames ')'

	'('  shift 187


state 91
	systemright : GRANT .  (75)
	security_right : GRANT . OBJRIGHT
	security_right : GRANT . SYSRIGHT

	OBJRIGHT  shift 188
	SYSRIGHT  shift 189
	.  reduce 75


state 92
	systemright : REVOKE .  (76)
	security_right : REVOKE . OBJRIGHT
	security_right : REVOKE . SYSRIGHT

	OBJRIGHT  shift 190
	SYSRIGHT  shift 191
	.  reduce 76


state 93
	security_right : SET . PARENT ROLE
	security_right : SET . CHILD ROLE
	security_right : SET . TOP ROLE
	security_right : SET . USER SECURITY LEVEL
	security_right : SET . USER ALLOW SECURITY LEVEL
	security_right : SET . USER CURRENT SECURITY LEVEL
	security_right : SET . TABLE SECURITY LEVEL

	TABLE  shift 192
	USER  shift 193
	CHILD  shift 194
	PARENT  shift 195
	TOP  shift 196


state 94
	security_right : AUDIT . USER
	security_right : AUDIT . OBJRIGHT
	security_right : AUDIT . SYSRIGHT

	OBJRIGHT  shift 197
	SYSRIGHT  shift 198
	USER  shift 199


state 95
	security_right : NOAUDIT . USER
	security_right : NOAUDIT . OBJRIGHT
	security_right : NOAUDIT . SYSRIGHT

	OBJRIGHT  shift 200
	SYSRIGHT  shift 201
	USER  shift 202


state 96
	objectright : SELECT .  (213)

	.  reduce 213


state 97
	objectright : INSERT .  (214)

	.  reduce 214


state 98
	objectright : UPDATE .  (215)

	.  reduce 215


state 99
	objectright : YDELETE .  (216)

	.  reduce 216


state 100
	executor : USER . '(' usernames ')'
	executor : USER . '(' usernames ')' ',' ROLE '(' rolenames ')'

	'('  shift 203


state 101
	objectrights : objectright .  (212)

	.  reduce 212


state 102
	audit2 : AUDIT objectrights . ON tablename EXECUTED BY executor
	objectrights : objectrights . ',' objectright

	','  shift 204
	ON  shift 205


state 103
	auditright : systemright .  (221)

	.  reduce 221


state 104
	auditrights : auditright .  (220)

	.  reduce 220


state 105
	auditright : security_right .  (222)

	.  reduce 222


state 106
	audit1 : AUDIT executor .  (203)

	.  reduce 203


state 107
	audit3 : AUDIT auditrights . EXECUTED BY executor
	auditrights : auditrights . ',' auditright

	','  shift 206
	EXECUTED  shift 207


state 108
	noaudit2 : NOAUDIT objectrights . ON tablename EXECUTED BY executor
	objectrights : objectrights . ',' objectright

	','  shift 204
	ON  shift 208


state 109
	noaudit1 : NOAUDIT executor .  (204)

	.  reduce 204


state 110
	noaudit3 : NOAUDIT auditrights . EXECUTED BY executor
	auditrights : auditrights . ',' auditright

	','  shift 206
	EXECUTED  shift 209


state 111
	factor : '(' . expr ')'
	factor : '(' . expr error

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	OPLESS  shift 115
	YTRUE  shift 116
	YFALSE  shift 117
	IDENTIFIER  shift 118
	STRING  shift 119
	INTEGER  shift 120

	tablename goto 121
	fieldname goto 122
	seclevel goto 123
	expr goto 210
	term goto 125
	factor goto 126
	colref goto 127
	bool_value goto 128


state 112
	colref : SECLEVEL . '(' fieldname ')'
	colref : SECLEVEL . '(' tablename '.' fieldname ')'

	'('  shift 211


state 113
	factor : OPSUB . factor

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	OPLESS  shift 115
	YTRUE  shift 116
	YFALSE  shift 117
	IDENTIFIER  shift 118
	STRING  shift 119
	INTEGER  shift 120

	tablename goto 121
	fieldname goto 122
	seclevel goto 123
	factor goto 212
	colref goto 127
	bool_value goto 128


state 114
	select_list : OPMUL .  (187)

	.  reduce 187


state 115
	seclevel : OPLESS . OPMORE
	seclevel : OPLESS . ',' OPMORE
	seclevel : OPLESS . class ',' OPMORE
	seclevel : OPLESS . ',' range OPMORE
	seclevel : OPLESS . class ',' range OPMORE

	','  shift 213
	OPMORE  shift 214
	INTEGER  shift 215

	class goto 216


state 116
	bool_value : YTRUE .  (160)

	.  reduce 160


state 117
	bool_value : YFALSE .  (161)

	.  reduce 161


state 118
	tablename : IDENTIFIER .  (110)
	fieldname : IDENTIFIER .  (113)

	'.'  reduce 110
	.  reduce 113


state 119
	factor : STRING .  (156)

	.  reduce 156


state 120
	factor : INTEGER .  (155)

	.  reduce 155


state 121
	colref : tablename . '.' fieldname

	'.'  shift 217


state 122
	colref : fieldname .  (162)

	.  reduce 162


state 123
	factor : seclevel .  (158)

	.  reduce 158


state 124
	expr : expr . OPADD term
	expr : expr . OPSUB term
	select_sub_list : expr .  (190)

	OPADD  shift 218
	OPSUB  shift 219
	.  reduce 190


state 125
	expr : term .  (148)
	term : term . OPMUL factor