Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2000 permissions from backup

Status
Not open for further replies.
djj55

djj55

Programmer
Feb 6, 2006
1,761
US
Hello, if I change the permissions to a stored procedure in a database back that database up and then restore the database on a different server will the permissions be the same?

Thank you,


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
 
Sort by date Sort by votes
They should be. A full backup is a snapshot of the database at the end of the backup.
 
Upvote 0 Downvote
Yes they will.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Upvote 0 Downvote
Thank you both

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
254
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
238
CodeWell
CodeWell
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
189
dgillz
dgillz
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
189
dhookom
dhookom
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
104
intel233
intel233

Part and Inventory Search

Sponsor

Back
Top