Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Unanswered: user rights on table columns

    Hello,

    Is there any possibility to grant select right to user on specified columns of a table ?

    Or do i have to create a view for this column (an grant the according rights to it) ?

    d.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: user rights on table columns

    Originally posted by SeattleDirk
    Hello,

    Is there any possibility to grant select right to user on specified columns of a table ?

    Or do i have to create a view for this column (an grant the according rights to it) ?

    d.
    Of course you do this without creating view - check setting user permissions in EM

  3. #3
    Join Date
    Sep 2003
    Posts
    7
    Sorry i was a little bit imprecise..

    I got a Microsoft Data Engine (if i remember correctly ms sql svr 7.0 core) without any gui. So i need to set userrights with sql statements but i do not know.

    "grant [rights] on [table] to [user] " is the syntax i know but where to add the column names ??

    d.

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    BOL:

    GRANT
    Creates an entry in the security system that allows a user in the current database to work with data in the current database or execute specific Transact-SQL statements.

    Syntax
    Statement permissions:

    GRANT { ALL | statement [ ,...n ] }
    TO security_account [ ,...n ]

    Object permissions:

    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 } ]

  5. #5
    Join Date
    Sep 2003
    Posts
    7
    Mea Culpa! .. i forgot the brackets

    thanks a lot..

    d.

Posting Permissions

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