How to give permissions(administering permissions) to different users in sharepoint LIKE for a user, for a manager, for a system engineer and so on. I want differences in their accessibility to the site. How do I administer it? Do i have to use any tool or language? Kindly help
migrated from stackoverflow.com Aug 30 '12 at 14:40
This question came from our site for professional and enthusiast programmers.
Go to the
From here you can click on either
Once you've created groups and users that you can work with, you can now set permissions on individual libraries,folder/files and sites by either using the site's
EDIT to add to what was discovered in comments to this answer since you are also looking for Database permissions:
Assuming that your database is being run by a Microsoft SQL Server, you can use something like SQL Server Management Studio. Just make sure you match the right versions. For example, SQL Server 2008 which you can download here : microsoft.com/en-us/download/details.aspx?id=7593 This tool will let you manage your databases and permissions.
SQL Server Management Studio is a GUI tool, no programming language required. You log into your server and you're presented with a tree view of everything available to you. Find your database in the tree, right-click > click on Properties and a window will pop up where you can click on Permissions and view/modify the users' permissions. There a lot you can do, and you can also run SQL Queries if you want.
Also, here are some good tutorials to get you started:
Basic beginner's guide : http://technet.microsoft.com/en-us/library/bb934498(v=sql.100).aspx
Changing user permissions: http://www.fasthosts.co.uk/knowledge-base/?article_id=1170
Another on permissions (see answer) : SQL Server 2008: how do I grant privileges to a username?
Read this. It is from Microsoft's website. It explains "permission" groups that already exist that you can access and set users to and also explains how you can create custom groups based on your needs.
We need to add this user as one of the Site Collection Administrators for the CA Site. So from any of the CA pages navigate to
Follow this article Creating New/Additional SharePoint Farm Administrators to know step by step approach..
Hope this help