Mike & Doris Manning
mikedorism at adelphia.net
Mon Apr 19 08:17:43 CDT 2004
1) Right click on the name of any table, sproc, or view. 2) Choose "All Tasks" 3) Choose "Manage Permissions" As a general rule, you should not allow users access to the tables themselves. Inserts, Updates, and Deletions should all be handled through sprocs and views. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows Sent: Monday, April 19, 2004 7:56 AM To: Dba-SQL Subject: [dba-SQLServer] What am I forgetting? - SQL Permissions First of all, I am an SQL Novice, just kind of feeling my way thru things. I have just recently set up my SQL Server 2000, and tried to run an Access 2002 database against the SQL tables. Links are fine, I can view all the data, but I cannot remember where I adjust the settings to allow me to add or delete from the tables. I am suffering from a severe case of brain dead / spring fever (it was in the mid 80's here today) TIA Jeff Barrows Outbak Technologies, LLC Racine, WI www.outbaktech.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com