This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

srs.ncp_trustees table and views

Hi,

I'm querying the ncp_trustees table nad current_ncp_trustees view, I'm seeing a lot of entries where the rights column contains a 0 value, according to the documentation (this documentation https://www.novell.com/documentation/filereporter3/file_reporter_3_0_query/data/b1cfpk71.html#b1cfq464) this column can contain the following values:

0x01 = Read
0x02 = Write
0x04 = [undefined]
0x08 = Create
0x10 = Delete
0x20 = Access Control
0x40 = File Scan
0x80 = Modify
0x100 = Supervisor

So can someone tell me what it means when this column contains a value of 0?

My NFR installation is version 3.0 with an SQL Server back end.
  • 0
    mgordon,

    It appears that in the past few days you have not received a response to your
    posting. That concerns us, and has triggered this automated reply.

    These forums are peer-to-peer, best effort, volunteer run and that if your issue
    is urgent or not getting a response, you might try one of the following options:

    - Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
    all the other self support options and support programs available.
    - Open a service request: https://www.microfocus.com/support
    - You could also try posting your message again. Make sure it is posted in the
    correct newsgroup. (http://forums.microfocus.com)
    - You might consider hiring a local partner to assist you.
    https://www.partnernetprogram.com/partnerfinder/find.html

    Be sure to read the forum FAQ about what to expect in the way of responses:
    http://forums.microfocus.com/faq.php

    Sometimes this automatic posting will alert someone that can respond.

    If this is a reply to a duplicate posting or otherwise posted in error, please
    ignore and accept our apologies and rest assured we will issue a stern reprimand
    to our posting bot.

    Good luck!

    Your Micro Focus Forums Team
    http://forums.microfocus.com


  • 0
    mgordon,

    It appears that in the past few days you have not received a response to your
    posting. That concerns us, and has triggered this automated reply.

    These forums are peer-to-peer, best effort, volunteer run and that if your issue
    is urgent or not getting a response, you might try one of the following options:

    - Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
    all the other self support options and support programs available.
    - Open a service request: https://www.microfocus.com/support
    - You could also try posting your message again. Make sure it is posted in the
    correct newsgroup. (http://forums.microfocus.com)
    - You might consider hiring a local partner to assist you.
    https://www.partnernetprogram.com/partnerfinder/find.html

    Be sure to read the forum FAQ about what to expect in the way of responses:
    http://forums.microfocus.com/faq.php

    Sometimes this automatic posting will alert someone that can respond.

    If this is a reply to a duplicate posting or otherwise posted in error, please
    ignore and accept our apologies and rest assured we will issue a stern reprimand
    to our posting bot.

    Good luck!

    Your Micro Focus Forums Team
    http://forums.microfocus.com


  • 0
    mgordon novoit wrote:

    >
    > Hi,
    >
    > I'm querying the ncp_trustees table nad current_ncp_trustees view, I'm
    > seeing a lot of entries where the rights column contains a 0 value,
    > according to the documentation -(this documentation
    > https://www.novell.com/documentation/filereporter3/file_reporter_3_0_q
    > uery/data/b1cfpk71.html#b1cfq464)- this column can contain the
    > following values:
    >
    > 0x01 = Read
    > 0x02 = Write
    > 0x04 = [undefined]
    > 0x08 = Create
    > 0x10 = Delete
    > 0x20 = Access Control
    > 0x40 = File Scan
    > 0x80 = Modify
    > 0x100 = Supervisor
    >
    > So can someone tell me what it means when this column contains a value
    > of 0?
    >
    > My NFR installation is version 3.0 with an SQL Server back end.




    --
    mgordon,

    You can get 0 when you have assigned a trustee, without giving granting
    any permissions.

    Forinstance if you ran a custom query report like:

    SELECT
    trustees.fullpath,
    trustees.rights,
    trustees.rights_string,
    trustees.trustee_display_name
    FROM
    srs.current_ncp_trustees AS trustees
    WHERE
    trustees.rights = 0

    You will see some fullpaths with rights = 0 the rights_string = "" and
    a trustee_display_name with some value.

    If you look up this path in iManager you will find a permission
    assigned to the user listed in the trustee_display_name with none of
    the SRWCEMFA options set.

    Hope this helps,
    Rich Lagger
    Product Specialist.