Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to set user with specific permission or roles

Author  Topic 

ipm.si888
Starting Member

1 Post

Posted - 2015-03-03 : 05:22:06
Dear All,

I am new here and glad to find this place to ask the questions I have.

I am currently using Windows 2008 with SQL Server 2008 r2. What I would like to do is to create a new SQL user, which can allow him to see the tables as well as stored procedures in the database, at the same time, block him/her to access the Login Security function so that he/she does not mess up the Login details of other users.

These are the info that I can provide now. If you need further details to help on this issue, feel free to inform here.

Thank you.



regards,
CC
   

- Advertisement -