Re: Complete Neophyte Question(s)

James (minorkeys@xxxxxxxxx) writes:
I guess it just seems backward that you'd grant permissions to these by
default and effectively force them to opt out...and from what I can
gather, all of our production databases are the reverse. So much for
looking to Northwind for an example =).

The only way a user can get access to a table, is that he granted permission
to, directly or indirectly. If nothing is ever granted, there is not much
to access. Apparently someone had granted rights to public in Northwind.

Furthermore, SELECT permissions implies VIEW DEFINITION.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Time to shrink a database
    ... Northwind and its Order Details too. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... Publication: NorthwindProducts ... PublisherDB: Northwind ... A snapshot of 1 articlewas generated. ... > check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)