Sharing Tables in Sybase

The status of your Sybase account allows to create tables not databases. Therefore you will be granting access per table basis. The name of your database is your account name. You can create tables and other objects and share them. The sharing process involves adding other users to your database and then granting them access. Please follow the procedure outlined below:

Change the "dbo use only option" on your database.This allows others to use your database. Run checkpoint on your database once you have switched the context so that the changes you have made are effective (here your_database_name should be your login ID).
```
 
	   use master
	   go
	   sp_dboption your_database_name, "dbo use only", false
	   go
	   use your_database_name
	   go
	   checkpoint
	   go
```
Add the name of each user to your database, using the sp_adduser command. Run this command once for each user. (The command seems to be adding one user at a time.) The login name of the user is the login for the SYBASE account.
```
 sp_adduser login_name_of_the_user_you_want_to_add 
```
Once you have added the users, you can grant them any permission you would want to for each table. You can only grant access for one table at a time not for the whole database.
The possible permissions are select, insert, delete, references, all. For example the CSC432 class is given only select permission to use the DreamHome database. To give access with type all :
```
 grant all on your_table_name to user_list 
```
The user list is the login names of all the users you want to add separated with commas.
Users can access databases created by others as follows (here other_database_name refers to the database you are trying to access): You can refer to a table tab in the other_database_name as other_database_name..tab, e.g.,
```
 
	select * from pyolum..Branch
	go	
```
should print the contents of pyolum's Branch table assuming you have access. Alternatively, you can change the database explicitly as
```
 
	use pyolum
	go	
```
Then
```
 
	select * from Branch
	go	
```
produces the same results as the above.

Please refer to the sybooks online help for details. The complete format of all the commands are available under SYBASE SQL Server Release 10.0.2 (Sybooks v.3) and the SYBASE SQL Server Reference Manual.