I have all the permissions. Can you explain where i can see this information.

Also in the error log i can see the spid who has thurned the db on. But How can i find to which user this SPid had belonged to? (its this isue had occured 2 days back)