Re: Error accessing sql server

From: Brian Brown (BrianBrown_at_discussions.microsoft.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 11:11:01 -0800

Ricardo,

You can do this using osql. First open a command prompt and type in osql -U
<username>. Once you are logged in you can grant the user access to the
database just type in sp_grantlogin <username> then GO. After the user has
access to the database you can grant the user specific permissions to the
tables/stored procedures/views/etc. (e.g. GRANT SELECT ON <tablename> TO
<username>).

I hope this helps.

Relevant Pages

  • Create table rights
    ... I have given a user ddladmin to a database, but this user still can't create ... I tried to "grant create tables to username" that ran sucessfully ...
    (microsoft.public.sqlserver.security)
  • Granting access on MySQL
    ... I need to grant a user access to a database. ... mysql> grant all on databasename.* to username; ... I got no error messages, but I after connecting as the user, I couldn't use the database. ...
    (freebsd-questions)
  • RE: user permissions in a database as a whole or tables
    ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: user permissions in a database as a whole or tables
    ... like PDF better but that was not helping this time either. ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)