Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2010
    Posts
    5

    Unanswered: Permission on ms sql 2000

    I am using ms sql 2000. There is a table that stores master files and i want to restrict some users from editing the columns. How can i do this?

    Any help will be appreciated

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I need more information in order to help you.

    How do your users access your database? Do they use a web page, a "fat client", SQL tools like Query Analyzer and Enterprise Manager, or something different? Do your users use Windows Authenication or SQL Autherntication? Do all users have their own logins, or do they share a small number or even one login?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Oct 2010
    Posts
    5

    ms sql permision

    The user are using enterprise manager to query some data in the master table.

    the sql. the user also use sql Authenication. each user have it own login.

    Hope this are the information you require.



    Quote Originally Posted by Pat Phelan View Post
    I need more information in order to help you.

    How do your users access your database? Do they use a web page, a "fat client", SQL tools like Query Analyzer and Enterprise Manager, or something different? Do your users use Windows Authenication or SQL Autherntication? Do all users have their own logins, or do they share a small number or even one login?

    -PatP

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    To make things easier, create a role for the users in question.

    Grant the permissions required to this role, and add the users to this role. Remember, if the users are members of either the sysadmin server role, the Domain Admins NT group, or the local administrators group on the box, or are members of the db_owner role in the database, this will not work, and you will have to determine how to back them out of these roles.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If the users have either db_owner, db_datawriter, or sysadmin permissions then you still have a challenge. Otherwise just fix their permissions for those tables. SQL Server starts with the assumption that you have no permissions until the administrator or database owner grants you permissions.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Oct 2010
    Posts
    5

    Permission on ms sql 2000

    Phelan,

    i created a role and deny users to delete and update but i get the following error

    Server: Msg 229, Level 14, State 5, Line 1
    SELECT permission denied on object 'GLSETUP', database 'FOSA', owner 'dbo'.

    this is on query analyser

    and on the enterprise manager the error is

    You may not have permission to perform this operations or the object glsetup may no longer exist in the database


    On the role i had deny the update and delete.

    Quote Originally Posted by Pat Phelan View Post
    If the users have either db_owner, db_datawriter, or sysadmin permissions then you still have a challenge. Otherwise just fix their permissions for those tables. SQL Server starts with the assumption that you have no permissions until the administrator or database owner grants you permissions.

    -PatP

  7. #7
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Read the last sentence of the post you quoted.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  8. #8
    Join Date
    Oct 2010
    Posts
    5

    Cool

    i got a solution by using a trigger below. Otherwise thanks alot. I have learnt something out of it.

    alter TRIGGER updatecustbal ON customerbalance
    INSTEAD OF update,delete
    AS
    BEGIN
    RAISERROR ('No Editing Of this file',16,1)
    ---RETURN 50000
    END

    PSIGEI

    Quote Originally Posted by psigei View Post
    Phelan,

    i created a role and deny users to delete and update but i get the following error

    Server: Msg 229, Level 14, State 5, Line 1
    SELECT permission denied on object 'GLSETUP', database 'FOSA', owner 'dbo'.

    this is on query analyser

    and on the enterprise manager the error is

    You may not have permission to perform this operations or the object glsetup may no longer exist in the database


    On the role i had deny the update and delete.

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    SELECT permission is still denied...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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