1

Topic: Read only view?

Colleagues, prompt, in 2012 server what method to make representation ReadOnly is optimal?

2

Re: Read only view?

Optimal for whom/that?
The idle time - representation with with view_metadata and the empty trigger instead of insert, update, delete.

3

Re: Read only view?

On speed of development optimal not to produce triggers and  lines "revoke insert/update"

4

Re: Read only view?

Cammomile wrote:

On speed of development optimal not to produce triggers and  lines "revoke insert/update"

Why they cannot be produced?

5

Re: Read only view?

To that  laziness?

6

Re: Read only view?

Cammomile wrote:

not to produce triggers

Produce one DDL-trigger which on adding to representation extended prioperty the certain content will produce all necessary infrastructure.
Or too laziness?

7

Re: Read only view?

Cammomile wrote:

Colleagues, prompt, in 2012 server what method to make representation ReadOnly is optimal?

To make all fields  calculated.
Though

Field = cast (a field as )

8

Re: Read only view?

I while stopped on a variant
UNION SELECT
....
WEHRE 1 = 0

9

Re: Read only view?

Cammomile;
And to what such crutches, it is impossible to close access at security level