Post reply

Terms in plain English .... please

  • February 3, 2012 at 6:13 am

    #1442367

    raotor (2/3/2012)

    Am I correct in thinking that using schemas can be useful because you can grant users access at the schema level and thus you could deny users access to the "Master" schema-based tables without having to individually specify tables?

    Exactly, and that's one of the main reasons you would use them

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 3, 2012 at 6:30 am

    #1442379

    A link I'd advise reading from TechNet:

    Summary: SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.

    http://msdn.microsoft.com/en-us/library/dd283095(v=sql.100).aspx

    It gives a reasonably complete overview of database object schemas which is going to perhaps fill in the gaps.

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply