Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

Of Interest

Be responsible for your future
Enter the USA legally!

Visa, Green Card, Citizenship, Passport
Consultation Services

Sybase » DDL » DBA »

Object Permissions


Object security is fairly straightforward. Here are some examples:

grant all on invoice to jsmith
grant select on invoice to wriker
grant update on invoice to wriker
revoke select on invoice from wriker

Stored procedure security allows you to grant access on a business logic basis.
For example, if you had a stored proc that updated the invoice table and selected
data from the customer table, you could grant the execute priviledge on the stored
proc, and you're done. The user would be able to run the procedure to update/select
from the tables, but could not get at the tables directly.

grant execute on proc_upd_invoice to jsmith

Sybase : Related Topics

Sybase : DDL : Creating a proxy table
Sybase : DDL : Tables which span multiple segments
Sybase : DDL : Moving an object to another segment

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2019 Stoltenbar Inc All Rights Reserved.