Setting Object Ownership

By default, the Admin account owns all objects in a database (and the database itself). You can change the ownership of any object and assign the object to a specific user or group . The owner of an object has administrative-like powers. That individual can assign permissions for the object and thereby control who else can gain access to that object. However, the Admin account will also have full privileges to every object, regardless of ownership.

Set Ownership

graphics/1_icon.jpg

Start Access, type Admin as the user name , press Tab, and then enter the password for the Admin account.

graphics/2_icon.jpg

Click the Tools menu, point to Security, and then click User And Group Permissions.

graphics/3_icon.jpg

Click the Change Owner tab.

graphics/4_icon.jpg

Click the Object Type list arrow, and then select the type of object you want to own.

graphics/5_icon.jpg

Click the specific object in the Object list.

graphics/6_icon.jpg

Click whether you want to assign the object to a group or a specific user.

graphics/7_icon.jpg

Click the New Owner list arrow, and then select the user or group you want.

graphics/8_icon.jpg

Click Change Owner.

graphics/9_icon.jpg

Click OK.

graphics/12inf07.jpg

Did You Know?

You own the ones you create . The user who creates a table, query, form, or report is, by default, the owner of the object and has full control over it.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net