Post reply

Sql server 2000 Security

  • February 10, 2006 at 7:25 am

    #168232

    Dear All,

    Can we give the permission of the database level. I am not able to run my stored procedure when I am giving the database role db_datareader and db_datawriter. what shuold I do please let me know.

    thanks

     

  • February 10, 2006 at 7:28 am

    #620118

    1. create a login using enterpise manager.

    2. Make him part of public role and give access to the database

    3. Use below scripts

    Grant select on <table_name> to <Login_Name>

    Grant insert on <table_name> to <Login_Name>

    Grant update on <table_name> to <Login_Name>

    Grant delete on <table_name> to <Login_Name>

    Grant exec on <procedure_name> to <Login_Name>

     

  • February 10, 2006 at 10:02 am

    #620215

    An alternative to individual grant statements for SELECT, INSERT, UPDATE, DELETE is to make the database user a member of the fixed database roles, db_datareader and db_datawriter.  That is, if you want the user to be able to read and write to all user tables in the database.

    Greg

    Greg

  • February 16, 2006 at 3:54 am

    #621296

    Can we give the permission of the database level. I am not able to run my stored procedure when I am giving the database role db_datareader and db_datawriter. what shuold I do please let me know ASAP, I am in big problem.

    thanks

  • February 16, 2006 at 3:54 am

    #621295

    Can we give the permission of the database level. I am not able to run my stored procedure when I am giving the database role db_datareader and db_datawriter. what shuold I do please let me know ASAP, I am in big problem.

    thanks

  • February 16, 2006 at 4:47 am

    #621304

    some in the role db_securityadmin can assign execute permission.

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

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