Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question
add comment

migrated from stackoverflow.com Aug 30 '12 at 14:40

This question came from our site for professional and enthusiast programmers.

3 Answers

Go to the Site Actions button on the top-right of your page and click on Site Settings

From here you can click on either People and Groups or Advanced Permissions to see your users and groups. It also allows you to create new groups/users and set permissions at site-level.

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 Site Settings, or in the case of a library, just open the drop down menu for it and select Manage Permissions. From here you can add in your groups and users and specify what permissions you want them to have.

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

Logging in : http://blog.arvixe.com/how-to-use-microsoft-sql-server-2008-to-connect-to-your-database/

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?

share|improve this answer
    
I know this part of setting permissions. This works fine when I have data stored in a sharepoint list. But how do I set permissions when I have my data stored in a database? –  celebrate celeb Aug 29 '12 at 14:05
    
@celebrateceleb Ah, for this you need to log into the SQL Server with the SQL management studio. You can't do this from SharePoint. –  XToro Aug 29 '12 at 14:09
    
Is there any tool to do it? Or it should be hard coded? –  celebrate celeb Aug 29 '12 at 14:29
1  
@celebrateceleb 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. What are you running to host your databases? –  XToro Aug 29 '12 at 17:04
    
SQL Server 2008. Is SQL Server Management Studio a tool or do I have to give queries/use programming language to administer rights? –  celebrate celeb Aug 30 '12 at 6:31
show 3 more comments

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 Site Actions -> Site Settings

In the Site Settings page, in the Users and Permissions section, click the Site Collection Administrators link

In the Site Collection Administrators field enter the account of the user and then click .

Follow this article Creating New/Additional SharePoint Farm Administrators to know step by step approach..

More over look Share point help documents Manage SharePoint groups and Permissions for site collection administrators.

Hope this help

share|improve this answer
    
I know this part of setting permissions. This works fine when I have data stored in a sharepoint list. But how do I set permissions when I have my data stored in a database? –  celebrate celeb Aug 29 '12 at 14:10
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.