User permissions

From: Chris Themistocli (cthemistocli@aw.com.cy)
Date: 11/11/02 

From: "Chris Themistocli" <cthemistocli@aw.com.cy>
Date: Mon, 11 Nov 2002 06:13:25 -0800

Is there a transact-sql or other way that I can use to
grant permissions to all objects in a database to a
specific user? The only way I could find is to go through
all objects (tables, stored proc and views) by using the
Enterprise Manager.

Relevant Pages

  • Re: Grant Insert Permission Freezing
    ... I have tried through Enterprise Manager and by executing at statement ... I kicked everyone out of the database so I am the only ... But when I try to grant permissions to table YYY the ...
    (microsoft.public.sqlserver.security)
  • Grant Insert Permission Freezing
    ... I have one table that I cannot grant permissions on. ... I have tried through Enterprise Manager and by executing at statement ... I kicked everyone out of the database so I am the only ...
    (microsoft.public.sqlserver.security)
  • RE: Big queries
    ... One can “compact” a SQL Server database by using the SQL Server Enterprise ... Manager console or Transact-SQL to manipulate database settings. ... dialog window or to automatically shrink the database using the ... If you are wondering if the Transact-SQL can be run from within Access, ...
    (microsoft.public.access.queries)
  • RE: Problems with upgrade to WSS 3.0
    ... \par RESTORE (Transact-SQL) ... \par During the restore process, the upgrade of the database is also performed. ... \par Install Windows SharePoint Services 3.0 on a stand-alone computer ... it is recommended that you have a copy of database in case any potential risks. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Backing up related databases
    ... Have you considered using the following Transact-SQL command: ... You can use it to backup your entire database. ... your database) within SQL Server Books Online (look in the SQL Server ...
    (microsoft.public.sqlserver.tools)