How to limit access to a table
Posted on 2008-10-07
Hi Experts, I have a database table I would like to limit access on. The table will hold credit card numbers and will be located in it's own schema.
Database A - All Other Tables and the application logs into this database
Database B - Table: CreditCards .. nothing else
Database A - database function (getCreditCard) and stored procedure (saveCreditCard) will be used to fetch and save the credit card information.
How can I define the security on table "CreditCards" so that only the stored procedure/function of database A can access the table? I don't want to be able to select from the table from Database A at all, except through the procedure/function.