Give Grant Access or Deniy From Client pc

شباب

الحمد لله حصلت الحل

بس حبيت أفيدكم

و أحطة لكم

و أي مساعدة أنا حاضر

------------------ Give User Permassion ------------------------

Examples

A. Grant statement permissions

This example grants multiple statement permissions to the users Mary and John, and the Corporate\BobJ Windows NT group.

GRANT CREATE DATABASE, CREATE TABLE

TO Mary, John, [Corporate\BobJ]

* * *

B. Grant object permissions within the permission hierarchy

This example shows the preferred ordering of permissions. First, SELECT permissions are granted to the public role. Then, specific permissions are granted to users Mary, John, and Tom. These users then have all permissions to the authors table.

USE pubs

GO

GRANT SELECT ON authors TO public

GO

* * *

GRANT INSERT, UPDATE, DELETE ON authors TO Mary, John, Tom

GO

* * *

C. Grant permissions to a SQL Server role

This example grants CREATE TABLE permissions to all members of the Accounting role.

GRANT CREATE TABLE TO Accounting

* * *

D. Grant permissions using the AS option

The Plan_Data table is owned by the user Jean. Jean grants SELECT permissions, specifying the WITH GRANT OPTION clause, on Plan_Data to the Accounting role. The user Jill, who is member of Accounting, wants to grant SELECT permissions on the Plan_Data table to the user Jack, who is not a member of Accounting.

Because the permission to GRANT other users SELECT permissions to the Plan_Data table were granted to the Accounting role and not Jill explicitly, Jill cannot grant permissions for the table based on the permissions granted through being a member of the Accounting role. Jill must use the AS clause to assume the grant permissions of the Accounting role.

/* User Jean */

GRANT SELECT ON Plan_Data TO Accounting WITH GRANT OPTION

/* User Jill */

GRANT SELECT ON Plan_Data TO Jack AS Accounting

------------------ Deny Permassion from the user ------------------------

Examples

A. Deny statement permissions

This example denies multiple statement permissions to multiple users. Users cannot use the CREATE DATABASE or CREATE TABLE statements unless they are explicitly granted the permission.

DENY CREATE DATABASE, CREATE TABLE TO Mary, John, [Corporate\BobJ]

* * *

B. Deny object permissions within the permission hierarchy

This example shows the preferred ordering of permissions. First, SELECT permissions are granted to the public role. After this, specific permissions are denied for users Mary, John, and Tom. These users then have no permissions to the authors table.

USE pubs

GO

GRANT SELECT ON authors TO public

GO

DENY SELECT, INSERT, UPDATE, DELETE ON authors TO Mary, John, Tom

* * *

C. Deny permissions to a SQL Server role

This example denies CREATE TABLE permissions to all members of the Accounting role. Even if existing users of Accounting have been explicitly granted CREATE TABLE permission, the DENY overrides that permission.

DENY CREATE TABLE TO Accounting

اخوكم

الشكر يا أستاذ طارق إبراهيم

لكن الحمد لله

حليتها

و ما ظنيتها تنحل

و الفضل لله عز وجل

والشكر لكم على كل حال

عموما كنت أسوي الصلاحيات من خلال الأنتربرايس مانيجر

و الحين صارت من أصل البرنامج

في شاشة صغيرة أضافية

عموما الكود تجميعي

أي ملاحظة علية

أو أستفسار

أنا حاضر

أخوكم