ASE 16 : missing token in master.dbo.spt_values

[former_member89972]

The token #205,  'Grant'  existing in master..spt_values in ASE  15.5 is dropped from ASE 16 version.

Any reason why this could be ?

One of our scripts malfunctioned because it expected the token "Grant" at #205

Ran query below  to find the tokens and names

select left(v.name,40) as name, v.number from master.dbo.spt_values v where v.type='T'

go

ASE 15 list

TOKEN VALUES                          -1

References                           151

Set Proxy                            167

Select                               193

Insert                               195

Delete                               196

Update                               197

Create Table                         198

Create Database                      203

Grant                                205

..... /<snip>

ASE 16 list

Token Values                                      -1

Select Builtin                                     5

DBCC Checkalloc                                   17

DBCC Checkalloc Any Database                      18

DBCC Checkcatalog                                 21

DBCC Checkcatalog Any Database                    22

Allow Hadr Login                                  23

DBCC Checkdb                                      25

DBCC Checkdb Any Database                         26

DBCC Checkindex                                   29

DBCC Checkindex Any Database                      30

DBCC Checkstorage                                 33

DBCC Checkstorage Any Database                    34

DBCC Checktable                                   37

DBCC Checktable Any Database                      38

DBCC Checkverify                                  41

DBCC Checkverify Any Database                     42

DBCC Fix_text                                     45

DBCC Fix_text Any Database                        46

DBCC Indexalloc                                   49

DBCC Indexalloc Any Database                      50

DBCC Reindex                                      53

DBCC Reindex Any Database                         54

DBCC Tablealloc                                   57

DBCC Tablealloc Any Database                      58

DBCC Textalloc                                    61

DBCC Textalloc Any Database                       62

DBCC Monitor                                      64

DBCC Tune                                         65

Setuser                                          136

References                                       151

Set Proxy                                        167

Select                                           193

Insert                                           195

Delete                                           196

Update                                           197

Create Table                                     198

Create Database                                  203

Create View                                      207

Create Trigger                                   221

.... <snip>

Avinash

[dan_thrall]

Hi Mark, Avinash,

You are correct, with the introduction of granular permissions in ASE 15.7 ESD 2 these explicit tokens are no longer present in spt_values. 

HTH

Dan