h1

Cap6. DCL pt. securitatea BD

March 18, 2010

Windows Server Authentification, Sql Server authentification (folosire mssql enterprise manager pt.setare permisiuni useri etc.; create roles, database roles privileges on mssql enterprise manager)

Clauzele care folosesc DCL:

SELECT,INSERT,UPDATE,DELETE.,EXEC. (Execute.),DRI. (Declarative referential integrity.) (lasa un utilizator sa adauge o constrangere FOREIGN KEY intr-o tabela.),CREATE TABLE,ALTER TABLE,DROP TABLE,CREATE,ALTER,DROP,BACKUP DATABASE.( Lets the user ID back up an entire database to a backup device.),BACKUP LOG. (Lets the user ID back up a database transaction log to a backup device.),CREATE DATABASE.,REFERENCES. (Lets a user ID refer to a column in a table or view in a foreign key or check constraint (Tip 153 will show you how a user-ID can use a foreign key or check constraint to determine the values in a column-even if the user-ID is denied SELECT privilege on the column or the entire table.),USAGE. (Lets the user ID use domains (named sets of legal column values), user-defined character sets, collating sequences, and translations. For example, without USAGE privilege on a domain, a user ID cannot CREATE a table with a column that uses the domain name as its data type.)

CLAUZELE GRANT SI REVOKE sunt folosite la DCL (pt.acordare respectiv retragere permisiuni pt.useri)

CLAUZA GRANT:

GRANT CU SELECT:

GRANT CU INSERT:

GRANT UPDATE:

GRANT DELETE:

GRANT REFERENCES:

GRANT ALL:

CLAUZA REVOKE:

Clauza GRANT SI REVOKE pt.view-uri:

Exemplul1:

Exemplul2:

  • Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: