Privileges for DB_EXTENDED_PROPERTY on Version 12 and earlier

0

Is the GRANT DBA privilege required to call DB_EXTENDED_PROPERTY for a different database, from a Version 12 or earlier database?

Testing indicates "yes" but the V12 Help is silent on the subject of privileges for DB_EXTENDED_PROPERTY.

For Version 16 or later, GRANT MONITOR or GRANT SERVER OPERATOR is required and documented.

asked 01 Apr '17, 08:21

Breck%20Carter's gravatar image

Breck Carter
32.5k●539●724●1050
accept rate: 20%

One Answer:
active answersoldest answersnewest answerspopular answers
1

According to the v16 What's New docs, no privileges should be necessary for v12 and below:

Returning information for other databases now requires privileges For version 12 and earlier databases, you did not need any permissions to execute the following system procedures and functions to return information for any database.
[...]
* DB_EXTENDED_PROPERTY function [System]
[...]

With 12.0.1.4403, I can confirm that behaviour: A restricted user with no particular privileges connected to his database 0 (db_id 0) can query the properties of another database 1 (although he is no user there at all), such as

select db_name(), db_name(1), db_extended_property('File', 'system', 1);

returns

 'MyDatabase', 'demo' , 'C:\Users\Public\Documents\SQL Anywhere 12\Samples\demo.db'

Similarily, calling sa_db_info() and sa_db_properties() list the properties of all loaded databases when called by that user.

permanent link

answered 02 Apr '17, 09:39

Volker%20Barth's gravatar image

Volker Barth
39.3k●355●539●809
accept rate: 33%

edited 03 Apr '17, 03:31

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×1

question asked: 01 Apr '17, 08:21

question was seen: 1,116 times

last updated: 03 Apr '17, 03:31

Related questions