Database Tutorials

Welcome to Dream.In.Code
	Become an Expert! Join 300,461 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,667 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

MSSQL 2000 Permissions

MSSQL 2000 Permissions, What are:

Options

Mikhail

21 Apr, 2008 - 06:21 PM

Post #1

Hello, in this tutorial I am going to explain what permissions are in Microsoft SQL Server 2000.

SQL Server 2000
Some SQL Experience

So what are permissions?
Permissions are used to determine actions that user(s) can perform on SQL Server or in database. Permissions are usually granted according to group membership(s) and role membership(s), in some cases they are also granted according to login ID, also users must have appropriate permissions before they can do anything that changes database or even accesses data. There are three types of permissions that are used in SQL Server.

Three types of Permissions:

Object permissions
Object permissions control access to the tables,views,columns, and stored procedures. You as a SQL Administrator can control these types of permissions by doing any of the following: Granting, Denying or even Revoking ability to restrict use of any particular statement or stored procedures, you can take this for example: You can grant user the right to SELECT and UPDATE Information, but deny the right to INSERT and DELETE information.
Statement permissions
Statement permissions control administrative actions, such as creating or adding objects to a database. By default members of System Administrators role and Database owners, are allowed such actions, however if there is a normal user, which needs to do something specific to a database such as CREATE RULE or CREATE TABLE, System Administrator and or Database Owner, can grant this type of permission as well revoke it.
Implicit permissions
Implied Permissions, are permissions that come already predefined on System Administrator and Database account(s). Such permissions for a role cannot be changed or applied to other accounts unless these account are made members of a particular role. For example System Administrators can perform any action they want, such as extend database and even kill processes, You can't revoke or assign these right to other account individually they have to be members of a group.
Also Database Owners with Implied Permissions can perform any task they want on their database, such as: Delete, add, and change data, That user can also change table's definition and control the table(s) permissions.

This is for anyone who wants to know what permissions in SQL server are for and how they are used, how they may grant them this also explains how the permissions are used, also a notice for anyone who is reading this, when assigning permissions, be careful on what you're assigning, you wouldn't want to give someone untrustworthy permissions that could damage the system.

By: Mikhail of </D.I.C>