Re: SQL Server and Creating Tables/Queries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: MGFoster (me_at_privacy.com)
Date: 04/08/04 

Date: Thu, 08 Apr 2004 18:42:07 GMT

Laurie wrote:

> I have connected to a database through Access using the
> SQL server. I can see view the data and create reports but
> I can't create a table or query. I get an error message
> that I'm not log in as the database owner or system
> administrator. I will not be able to save changes to
> tables that I do not own. Is this a problem in Access or
> with the Software that I got my database from?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This is a permissions issue. Your signon (user name) needs to be
granted permissions on various objects.

If you are not the SQL Server DBA, ask her to make you a user on the
database you want to access & grant you permissions to do the various
things you want to do. 

-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQHWdDIechKqOuFEgEQL4zgCdFA36cG6ozr/3Pfd3UuHwnzM/MGsAn2tU
GlddPfU+Ccy/Z5l7c+a5UX0c
=lnAI
-----END PGP SIGNATURE-----

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: access or network problem ?
    ... The first thing to check is whether or not ALL users have full permissions ... 'types' of user - User, and Administrator ... The database is accessed via icons on desktop ... Double click icon - opens access then displays access error message ...
    (microsoft.public.access.security)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
    (microsoft.public.sqlserver.security)