Results 1 to 5 of 5

Thread: Access Rights

  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: Access Rights

    I created a new database role called OpsRepo in MS Sql Server 2000. I assigned a stored proc called get_null_vals to this role only.

    I log into Sql Query Analyser using windows authentication (non-administrator). I am able to execute the stored proc even though I am NOT in the OpsRepo role. However, I am in the public role.

    I was expecting a permission problem - this did not happen. Why?

    I would appreciate your help

    Thanks

    Yogesh

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Access Rights

    What rights does public have?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

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

    Re: Access Rights

    Originally posted by ykverma
    I created a new database role called OpsRepo in MS Sql Server 2000. I assigned a stored proc called get_null_vals to this role only.

    I log into Sql Query Analyser using windows authentication (non-administrator). I am able to execute the stored proc even though I am NOT in the OpsRepo role. However, I am in the public role.

    I was expecting a permission problem - this did not happen. Why?

    I would appreciate your help

    Thanks

    Yogesh
    Check if you (or your windows group) belong to db_owner role or sysadmin role on server.

  4. #4
    Join Date
    Aug 2003
    Posts
    7

    Re: Access Rights

    Originally posted by Brett Kaiser
    What rights does public have?
    My user name is in the public role. The tables which are accessed by the stored proc are also in public but not the stored proc itself.

    I've tried after bouncing the server - still it did not work.

    Thanks in advance for your help

    Yogesh

  5. #5
    Join Date
    Aug 2003
    Posts
    7

    Re: Access Rights

    Originally posted by snail
    Check if you (or your windows group) belong to db_owner role or sysadmin role on server.
    I am only in the public role; my id is not set up in any of the windows group

    Thanks in advance

    Yogesh

Posting Permissions

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