Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Post Unanswered: Column level security

    How can I impose column level security?

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    You can set up security on column level:

    GRANT
    { ALL [ PRIVILEGES ] | permission [ ,...n ] }
    {
    [ ( column [ ,...n ] ) ] ON { table | view }
    | ON { table | view } [ ( column [ ,...n ] ) ]
    | ON { stored_procedure | extended_procedure }
    | ON { user_defined_function }
    }
    TO security_account [ ,...n ]
    [ WITH GRANT OPTION ]
    [ AS { group | role } ]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •