Post reply

A basic doubt on ''sp_helprotect''

  • February 7, 2006 at 6:15 am

    #364912

    Hi All

    When executing 'sp_helprotect' to see the roles and the permissions i'm getting the following data under the field 'column' ,

    1. All

    2. All + New

    3. .

     

    I do understand the the first two. Can any body tell me what does the . ( a period) indiacate.

    Warm Regards

    Subair

  • February 7, 2006 at 7:42 am

    #619271

    If the protected object is a stored procedure or user defined function, the 'column' is not applicable and showed as '.' or null

     

  • February 7, 2006 at 7:55 am

    #619283

    Thanks for the reply,

    But object i'm checking is a table. Below is a sample of the data i'm getting. Here  delete and insert showing as '.', but update is showing  '(All+New)'

    When i check thru EM all three access(insert, update and delete) has given.

    ProtectType  Action           Column

    -------------------------------------

    Grant           Delete            .

    Grant           Insert             .

    Grant           Update           (All+New)

  • February 7, 2006 at 8:05 am

    #619299

    Yes.  "column" deos not apply to insert and delete as well. E.g. you cannot insert/delete certain columns for a record. Column level only applies to select and update.

     

  • February 7, 2006 at 8:14 am

    #619303

    Appreciate your help. Thanks you very much.

Viewing 5 posts - 1 through 4 (of 4 total)

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