Skip to Content

ASE 16 : missing token in master.dbo.spt_values

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 20, 2016 at 10:47 PM

    Assuming you're referring to the sysprotects.action=205 ... looks like there was a major update at some point in an early ASE 15.7 version (compare the legal values for sysprotects.action in the ASE 15.5 and ASE 15.7 SP100 versions of the Reference Manual : Tables documents) ...

    Some of the actions removed with ASE 15.7:

    grant (205)

    revoke (206)

    dump database (228)

    dbcc (317)

    I'm wondering if this was related to the introduction of granular permissions in ... what was it ... ASE 15.7 ESD #2 ... ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.