Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

VIEWS 2 Expand / Collapse
Author
Message
Posted Saturday, March 10, 2012 11:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 5,471, Visits: 23,502
Comments posted to this topic are about the item VIEWS 2

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1264774
Posted Saturday, March 10, 2012 6:36 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 5:10 PM
Points: 589, Visits: 2,436
nice and easy question since it is mostly what I am doing now
I would not have said that some time ago: I deleted a row in a view and discovered that the row in the parent table has been deleted too!!!! I always tought that a view "is a view", not that it could be an "interface" with a table!!!
Since then, I put only "SELECT" permission on the views to make sure that nobody messed up with the data base without knowing it!

Thanks for the question!
Post #1264791
Posted Monday, March 12, 2012 12:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
Nice back to basics question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1264971
Posted Monday, March 12, 2012 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 5,794, Visits: 8,006
A good, solid question. Too bad it's only worth 1 point, I think 2 points would have been called for here.


tilew-948340 (3/10/2012)
Since then, I put only "SELECT" permission on the views to make sure that nobody messed up with the data base without knowing it!

Many people do the reverse - they give nobody any permissions on the base tables and give permissions on views only. For insert and delete, that does not really change much, but for update and select, it's a good way to show only relevant information. For instance, if your table contains a column is_active and you have a view that includes WHERE is_active = 1 and does not include columns that are only relevant to non-active members, you would give permissions on that view to the relevant users and they would never be able to see data about inactive members - neither the members, nor the columns that are relevant for inactive members.
And if the view includes the WITH CHECK option, those people would also be unable to change active members to non-active members.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1265003
Posted Monday, March 12, 2012 2:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
Good job I wasn't in Oracle mode.

Nice question.
Post #1265019
Posted Monday, March 12, 2012 4:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 1,986, Visits: 1,612
Nice "real world" question today. Thanks.
Post #1265040
Posted Monday, March 12, 2012 4:46 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 3,683, Visits: 4,818
Good back-to-basics question.
Thanks, Ron


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1265050
Posted Monday, March 12, 2012 7:01 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:45 AM
Points: 1,684, Visits: 234
This was a good question, but please check your spelling before submitting the question.
In the options available to be checked, results was spelled wrong twice and delete was spelled wrong once.
This make a good question look bad.
Post #1265148
Posted Monday, March 12, 2012 7:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654
Thanks for an easy one

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #1265174
Posted Monday, March 12, 2012 7:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 579, Visits: 27,690
Excellent question, thanks
Post #1265175
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse