Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Sybase SQL ServerTMSecurity Features User's Guide [Table of Contents] Chapter 1: Introduction to Security in SQL Server

Security Features User's Guide

[-] Preface

Preface

This manual describes the security features available with Sybase SQL ServerTM release 11.0. It provides instructions and guidelines for using the security features provided with SQL Server. Security is discussed from the perspective of the non-administrative user.

Audience

This manual is intended for all users of SQL Server, but it particularly addresses non-administrative users who own database objects but do not have special roles such as that of System Administrator or System Security Officer. If you are an administrator who is interested in setting up a secure operating environment for SQL Server, read the Security Administration Guide, which describes how to administer the security features provided by SQL Server.

This user guide assumes that readers have some general understanding of SQL Server and can understand simple SQL statements.

How to Use This Book

This manual contains these chapters:

Related Documents

SQL Server relational database management system documentation is designed to satisfy both the inexperienced user's preference for simplicity and the experienced user's desire for convenience and comprehensiveness. The user's guide and the reference manuals address the various needs of end users, database and security administrators, application developers, and programmers.

Other manuals you may find useful are:

Conventions Used in This Manual

Formatting SQL Statements

SQL is a free-form language: there are no rules about the number of words you can put on a line or where you must break a line. However, for readability, all examples and syntax statements in this manual are formatted so that each clause of a statement begins on a new line. Clauses that have more than one part extend to additional lines, which are indented.

SQL Syntax Conventions

The conventions for syntax statements in this manual are as follows:

Table 1: Syntax statement conventions

Key

Definition

command

Command names, command option names, utility names, utility flags, and other keywords are in bold Helvetica in paragraph text and bold courier in syntax statements.

variable

Variables, or words that stand for values that you fill in, are in italics.

{ }

Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.

[ ]

Brackets mean that choosing one or more of the enclosed options is optional. Do not include brackets in your option.

( )

Parentheses are to be typed as part of the command.

|

The vertical bar means you may select only one of the options shown.

,

The comma means you may choose as many of the options shown as you like, separating your choices with commas that are to be typed as part of the command.

Case

You can disregard case when you type keywords:

SELECT is the same as Select is the same as select 

Obligatory Options {You Must Choose At Least One}

Optional Options [You Don't Have to Choose Any]

Ellipsis: Do it Again (and Again)...

An ellipsis (. . .) means that you can repeat the last unit as many times as you like. In this syntax statement, buy is a required keyword:

buy thing = price [cash | check | credit] 
[, thing = price [cash | check | credit] ]...

You must buy at least one thing and give its price. You may choose a method of payment: one of the items enclosed in square brackets. You may also choose to buy additional things: as many of them as you like. For each thing you buy, give its name, its price, and (optionally) a method of payment.

Expressions

Several different types of expressions are used in SQL Server syntax statements.

Table 2: Types of expressions used in syntax statements

Usage

Definition

expression

Can include constants, literals, functions, column identifiers, variables, or parameters

logical expression

An expression that returns TRUE, FALSE, or UNKNOWN

constant expression

An expression that always returns the same value, such as "5+3" or "ABCDE"

float_expr

Any floating-point expression or expression that implicitly converts to a floating value

integer_expr

Any integer expression, or an expression that implicitly converts to an integer value

numeric_expr

Any numeric expression that returns a single value

char_expr

An expression that returns a single character-type value

binary_expression

An expression that returns a single binary or varbinary value

If You Need Help

Help with your Sybase software is available in the form of documentation and Technical Support.

Each Sybase installation has a designated person who is authorized to contact Sybase Technical Support. If you cannot resolve your problem using the manuals, ask the designated person at your site to contact SybaseTechnical Support.


Sybase SQL ServerTMSecurity Features User's Guide [Table of Contents] Chapter 1: Introduction to Security in SQL Server