Special Users

There are two special types of users who implicitly get certain permissions — object owners and users with Superuser privilege. Ordinary users (other than these two types) must be granted specific permissions for them to be able to access the object in the desired manner.

Object Owner

Each object is associated with a user or group, which is referred to as its object owner. The object owner is special as far as the particular object is concerned and gets the following permissions on this object automatically:

1. 1. READ permission

2. 2. All extended permissions except Extended Delete

Usually, the object owner is assigned higher permissions through the applied permission set. Permission sets are discussed later in this chapter.

Managing Object Ownership

An object can only have one specified owner (dm_sysobject.owner_name) at a time, which can be a user or a group. By default, the user creating the object becomes the owner of that object. Object ownership can be reassigned to another...