The Multifunctioning DBA

Dec 10 2008   12:16AM GMT

Sybase Training Day 3

Colin Smith Colin Smith Profile: Colin Smith

In day 3 we covered another 5 sections so once again I am just going to go over what I found to be the most interesting.

I would say that I have two things in day 3 that I found to be very cool. First is permissions and how they work in Sybase. So first you have to have a login to the server. Once that is created you should be able to log on to the server but that does not mean that you can do anything yet. Next you have to have a user set up in the database or databases that you would like to work in. For instance if you wanted to log in and work in the Pubs2 Database you have to have a login to the server but also a user in the pubs2 database. Now that you have that you can say ‘use pubs2’ and get into the database. This still does not mean that you can do anything in the pubs2 database. now we get to object level security and your user has to have permisions to objects in the database in order to view and or manipulate thos objects. I love this layered approach to security and think that it is a great way do to things. This gives the DBA so many ways to accomplish what is needed.

The other thing on day 3 that I found to be just great was the bulk copy utility. This tool gives the DBA the ability to copy data into or out of a table. This means that I can copy all the contents of a table into a file and then using that same file I can copy that data into a different table if I need to. The one draw back to this is that BCP is a minimally logged event so you will need to enable the db option and then after you are done with the bcp operation you will want to run a full database dump because this operation will invalidate your transaction logs since Sybase does not fully log this type of event.

That is a very broad overview of day 3.  If you have any questions about anything more specific please let me know.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: